Help with a simple print macro

E

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top