Hi Roshin,
Start with the sheets hidden, ie change your macro so that the sheets
are hidden when the file is closed not opened & have a message that
macros must be enable for the file to work. When you distribute the
file to end users the sheets will be hidden & if macros are disabled
the users will only see your message.
btw, have a search of the ng's /forum for this issue & you'll find
there are a number of useful suggestions floating around.
hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread:
http://www.excelforum.com/showthread...hreadid=558385