Protect the workbook under ToolsProtectionProtect Workbook.

After you have hidden the sheet, that would be.

See Bob's caveat about Excel security.


Gord Dibben MS Excel MVP

On Fri, 30 May 2008 02:35:01 -0700, pjk@boro
wrote:

I have a workbook to which only i have the password. All other users open it
as "read only". Within the book are some hidden worksheets. However, even
when the book is opened as "read only", a user is able to unhide these
sheets. I've tried using "Tools-Options-View-Hide Tabs" &
"Format-Sheet-Hide", all to no avail.
Is there an easy way I can prevent this?
thanks in anticipation.