PDA

View Full Version : read only



chungtinhlak
01-08-2009, 04:50 PM
Is there away to make it so that when a user opens, excel ask for a password, they have to enter a password or else it will be read only and if they do enter the right password, they can make changes to it?

thanks

Artik
01-08-2009, 05:18 PM
Use (I think so) from menu Tools/Protection=> Protect Sheet... and/or Protect Workbook...

Artik

chungtinhlak
01-08-2009, 05:23 PM
that's not gonna work for me, all these are pivot tables, I want them to be able to move fields around but not save over the template, that's why read only is important

Artik
01-08-2009, 06:09 PM
Another way.
(for XL2003) From menu File/Save As.../ click on DropDownButton Tools, select General options... (probably. Sorry, I have polish version) :)
Type password in textbox Passoword to modify.

Artik

lucas
01-08-2009, 07:08 PM
If it's cloned from a template....ie a filename.xlt why would you care if they change it?