Viewing the macros
Thanks Dave, I created two subs one to hide them and one
to unhide them, then a thought struck me, the user can
simply hit the run macro button and pick the unhide from
the list, is there anyway to prevent the user from
hitting thr un button and seeing all the sub routines
that are available ?
-----Original Message-----
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 ?
.
.
|