Password Protect a Workbook

  • Thread starter Thread starter Asha
  • Start date Start date
A

Asha

I have a workbook that has 5 different worksheets. This
workbook is saved everyday with a new date behind the name
to reflect the current date data. I need to password
protect the entire workbook so that it holds for each time
it is saved. How do I do this? When I go to file->saveas-
..Tools-> and assign a password it works for that workbook,
but when I resave the workbook with a new name, I have to
reset it all. Can I automate this somehow or is there a
different way to do what I am trying to do. I only want
the password there so admin's can make changes. I want
everyone else to view the workbook in read only mode.

Thank you.
 
Mistake, Apologies to all

Alan said:
Should read,

If you're running XL 2002, open a blank workbook, click Tools > Options >
Macros > Security and check Medium in the dialogue box, (if its set to high
the macro
will be disabled and this wont work), exit the blank workbook, no need to
save it. If you're running any other version, this isn't necessary,
Click to expand...
 
Back
Top