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 ?