Microsoft Excel and MATLAB

Try hiding the sheet's you do not want anyone to see and than protect the sheet and only them basic things that the user when to use the program.

You can put .xls file as ready only. Any one can modify for data also hide the data.

Let me break my message into two parts

1. I agree with your first try of protecting the sheet with password but can't perform Matlab afterward. This is similar to my experience to other software operabiltiy with excel

2. I agree with the recent advise to hide the column (i.e with data parameters) but please try to test if you can lock the unhide default of excel (then relocate the cell "faraway on the same tab sheet") and if it wont work you may have use VBA Excel

Let me know if this wil work

Thanks for you all for replying

However, the read only option is useless because simply anybody can use the 'save as' option to take the excel file and do what ever he wants, besides the read only option prevents saving modifications, so the user can modify the file and unhide all the columns.

I tried protecting the sheet but it is useless.

Also I changed the visibility of the sheet to 'veryhidden' in VBA but the problem that there is nothing that prevents the modification of the file.

Any suggestions!!!!

thanks in advance

I think you could write matlab script for DB (MS Access or like) which is connected to Excel spreadsheet. So if you have access to DB you can get excel sheet and so on.

Its a longshot, but have you tried Open or Star Office.....?

dear Andy,

I am sorry but I did not get it. What do you mean by open or star!!!!

kik0kik0,

What Andy is referring to is open source software which does the same thing as Microsoft's Excel. Both should be available for free download from the Internet. If the problem is with access to the Excel file, the open source software may have different access levels which allow it to be read into Matlab without the user accessing the files otherwise.

--JMM

Very well put, thanks.

Open Office or Star Office, free downloads from Sun Microsystems. They are "lookalikes" of MS Office, but far far cheaper - free of you download them. Try googling them both.....

hehe, Andy,

are you going to mislead the top thread? or mistaking his meaning?

Star and Open ofice have different rules, so they might do exactly what he wants to do with MS Office!!!

That was the reason for mentioning them.....

Enthusiasm is a matter, while practice is another thing.

German has many excellent engineers, but rarely come here for their opinion; they may have their own group to busy with. Once you find and tell your idea to them, you may know what is imaginable and utility.

However I wish you to keep on your passion, some of them are also very useful.