Unlock Cells and Clear Contents

[ashani]

Hi
I'm trying to set the macro up to unlock multiple ranges and clear contents on those ranges from Sheet1,Sheet2 & Sheet3 and also to set the message box to say "xyz" - please can someone guide me.

Many thanks,

 

[ashani]

Hi @Michael M

yes that’s correct - the line is before the create PDF sub and both are in the same module.

thanks

 

[Michael M]

I can't test it at the moment....don't have Excel.
Hopefully someone can jump in and assist.
If you hover over the (filesavename) does it show the correct string ?

 

[ashani]

sure no worries - thanks for looking. I will post the question.
Once again thank you for all your help