View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Prevent unhide sheet

You could protect the workbook.
Tools|Protection|Protect workbook|Check Structure
(in xl2003 menus)

But this kind of protection is easily broken.

If you have information that shouldn't be seen by others, then don't put it into
excel.

If you have to put it in excel, then don't share that file with others.

acss wrote:

I know how to hide a sheet but i do i prevent a user from performing the
unhide? Does it have to be done using VB or hiding a particular toolbar?

Thanks,


--

Dave Peterson