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?