View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Flanagan[_2_] Bob Flanagan[_2_] is offline
external usenet poster
 
Posts: 81
Default Preventing other users from opening hidden worksheets

Be aware that password protection is extremely weak in Excel. Any user who
wants to can get at the hidden sheets, no matter how hidden, if they want
to. If a user should not see the data, then don't send it to them.

Robert Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"pjk@boro" wrote in message
...
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.