There are ways to ensure that the workbook is useless without macros, see
among severar
http://www.cpearson.com/excel/EnableMacros.aspx
but allow me to repeat: just protect the Workbook with a password, and the
user can not unhide sheets.

Best wishes Harald

"G" wrote in message
...
Thanks for everyone's help. The code works well, but ONLY if the user
selects ENABLE Macros. If the user chooses DISABLE Macros, they can
still
unhide the sheet.

Anything that we can set to turn on Macros, by default (no selection
required)?