Unprotect Worksheet Prompt

[Rohan]

I'm running Excel 97 (sorry!) and I have built a workbook which
obtains inputs from a number of users. All sheets are protected with
only the input cells unlocked. How do I switch off the prompts when
the workbook opens so that macros enable automatically and users
aren't prompted to unprotect 12 worksheets? Some users are not very
savvy, and struggle to hit "enable", then ESC 12 times.

 

[Jim Rech]

How do I switch off the prompts when the workbook opens so that macros
That's not possible since it would leave users with no way to stop malicious
code.

This isn't typical. Why are users getting this prompt?

--
Jim Rech
Excel MVP
| I'm running Excel 97 (sorry!) and I have built a workbook which
| obtains inputs from a number of users. All sheets are protected with
| only the input cells unlocked. How do I switch off the prompts when
| the workbook opens so that macros enable automatically and users
| aren't prompted to unprotect 12 worksheets? Some users are not very
| savvy, and struggle to hit "enable", then ESC 12 times.

 

[Rohan]

Thanks Jim - I suspected that would be true for the macro prompt - but
thought I may have been able to do something through workbook
properties. When I open the workbook, I am prompted to enable macros,
and then prompted to unprotect all the protected worksheets. Strange
but true...

 

[Gord Dibben]

I would suggest you have an Auto_open or Workbook_open macro that is giving
the prompt to unprotect the sheets.

Have a look in the Thisworkbook module for a workbook_open code or any general
module(s) for Auto-open code.

Gord Dibben Excel MVP