View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Hiding worksheets

Hi,

The short answer is you can't but you can make it more difficult. Alt+F11 to
open VB editor and if the 'Project' window and 'properties' window aren't
visible tap CTRL+R & F4 to show them

In the project window select the sheets in turn that you want to hide and in
the properties window set the 'visible' property to 'XlSheetVeryhidden'

Now click Tools|VBA Project properties and on the 'protection' tab check
'Lock project for viewing' and apply a password. Save close and re-open.

It's now as difficult as it gets and the only way to make the sheet visible
is from the VBA editor but it isn't secure because that's the nature of Excel
security
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Curtis" wrote:

Is there any way to keep users from un-hiding worksheets in a workbook?
However they do require access to other sheets (not hiiden) within the
workbook

Thanks
--
ce