Run Macro on Open

[AllisterB]

Hi

the Code either does not run when the Workbook is open orit does run but the code does not Protect all the Sheets in the workbook.

What is wrong ?

Thank You

Allister

Please Login or Register  to view this content.

[sintek]

Is the code in ThisWorkbook Module

[AllisterB]

Hi

No teh
Allister macro is in a module

[sintek]

So, if you want it to work...Put the code in ThisWorkBook Module

Or for std module use this...

Please Login or Register  to view this content.

[sintek]

I assume that as this is marked as solved, your original query has been answered...

As a courtesy, a response to a solution is generally a sign of confirmation...So others too, can learn...

Thanks for adding to my reputation +