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