What are you trying to protect? Unauthorised changing of the document, unauthorised viewing of the document, something else? I suspect that password protection will only protect from unauthorised changing, but not viewing, the spreadsheet. I don't have Excel handy to test this. Also, it may be possible to bypass password protection easily possibly even by opening the spreadsheet in OpenOffice or the like.
I tested this, you can save the spreadsheet with both the password to open and password to modify using the keystroke above. In addition Open office wont allow you to open a password protected Excel file
Excel 2000 according to the title. Make sure that the Excel menus are not abbreviated/collapsed - if there's a little down arrow symbol near the end of the menu click on it to expand the menu to the full set of options.
Yeah, definitely. Have done File/Save As - then gone to tools menu. there is no 'General Options' - have clicked options and the choices are View, Calculation, Edit, General, Colour, Chart, Custom List and Transistion. Under the General option tab, there is no option to password protect. Prob something so simple but unfortunately i'm not a computer buff!
On my version of Excel (and ISBN's I suspect) there is a security tab under 'Tools \ Options' from the main toolbar menu at the top, password protection can be activtaed here as well as the 'Save As' option
Hi, thanks everyone for your help. Under the Tools, protection option afaik this only protects the structure here and does not allow you to set a password to open option. On Excel 2002, you can do it from here. Think i finally have it done under File/save as/general options (in save as)