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 ?
.
|