Neil,
Make your sub private, i.e., Private mysub()
Bob L.

"Neil" wrote in message
...
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 ?
.

.