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