Help with a simple print macro

[Eee]

Guys,

I have inherited a spreadsheet with a macro built in. The macro is in
a sheet and simply prints the next worksheet in the book. However,
I've changed just one thing in the sheet to be printed, I've protected
it. Now I get the message 'you cannot use this message on a protected
sheet' When i depress the debug button it highlights 'Set rng =
WS.Range("A1").CurrentRegion '<<< Change' as being the problem.

Can this be resolved ?

 

[CLR]

One way would be to modify your macro to first "unprotect" the sheet, then do
your print stuff, then "re-protect" the sheet before ending.

Vaya con Dios,
Chuck, CABGx3