First, a word about Excel protection. You state that you want your file to
be "completely secure". That's not really possible. It's fairly common
knowledge that Excel files do not have "bullet proof" security. The general
intent of Excel passwords is to prevent accidental meddling and provide
somewhat of an obstacle to intentional meddling. It's akin to locking the
door to your home but not barricading the windows. Any motivated person with
fairly unimpressive technical skills could find a way in with only moderate
effort.

Now, if you're looking to cut down on the number of steps involved in
protecting 50 sheets, their contents, and the workbook structure, here's what
I do:

I make a Lock/Unlock workbook who's only function is to eithe lock-up or
unlock the workbook and sheet of the Excel file. Then keep that file in a
safe place.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Min" wrote:

I have created a workbook with about 50 sheets in it. How do I make it
completely secure? I want it to be read only, nothing at all editable and
preferably for the code not to be viewed.
I need to be able to edit it on a fairly regular basis so I don't
particularly want to have to enter a different password for each sheet.
Is this possible?