View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Ramage[_2_] Dave Ramage[_2_] is offline
external usenet poster
 
Posts: 41
Default Preventing someone from unhiding a sheet

You can hide them in VBA using the xlVeryHidden option-

Sheets("Sheet1").Visible = xlSheetVeryHidden

This way, the only way to unhide the sheet is to use VBA-

Sheets("Sheet1").Visible = True

Alternatively, you could protect the workbook
(Tools/Protection/Protect Workbook), although this will
prevent the user adding or deleting sheets etc. Also note
that any password under 10-15 characters long can be
broken fairly quickly.

Cheers,
Dave
-----Original Message-----
Hi all, I have put together a bulky sheet that uses
several sheets as data tables, the sheets are hidden, but
I want to prevent people from unhiding them, is there a
way to do this ?
.