No code. No macros.

Excel 2007: Review pane, Protect Workbook button, check Structure and
provide password.

Earlier versions: Menu Tools - Protection - Protect workbook, check
Structure and provide password.

Best wishes Harald

"G" wrote in message
...
Thanks, Harald. I would like to protect the workbook ... can you provide
guidance (e.g., modify your code)?

Again, thank you for your assistance.

G

"Harald Staff" wrote:

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)?