All sheet: read-only protection

**scubadiver007** · 11-01-2011, 08:11 AM

Hello,

I have gone through the various password protection methods but I can't get the workbook to do what I want.

I want to make sure every tab is read-only and any accidental modification requires a password.

"Protect sheet" protects the current sheet and I don't want to use a separate password for every tab. "Protect workbook" requires a password before it is opened.

Any ideas?

**royUK** · 11-01-2011, 08:49 AM

You have to protect the sheet individually. You can automate this with a macro

**Domski** · 11-01-2011, 08:54 AM

Something like this:

Please Login or Register  to view this content.

Dom

**scubadiver007** · 11-01-2011, 12:13 PM

Clever but the slight drawback is that there is no way to know if the password can be checked when unprotecting the worksheet so I am storing the string on a spreadsheet using the protect code and then I want to compare the string in the unprotect code.

For some reason my If statement isn't working.

Please Login or Register  to view this content.

**Domski** · 11-01-2011, 12:24 PM

Sorry, don't follow what you mean.

Dom

**scubadiver007** · 11-01-2011, 12:28 PM

I have created a password using the protect code but I have tried a completely different string of characters to unprotect the sheets and it works.

**scubadiver007** · 11-01-2011, 12:30 PM

Sorry, might be my mistake. I'm not using an input box.

EDIT: its fine now, thanks.

**royUK** · 11-01-2011, 12:32 PM

Where does your code actually set a value to strPWord?

**Domski** · 11-01-2011, 12:33 PM

Are you sure? If the sheets were protected with a password after you ran the Protect_Sheets code there's no way the other code would unprotect them without the correct password even with Excel 2003's slack security.

Dom