worksheet protection/macro

[wally]

Hi,
I have windows xp, home edition. After protecting a worksheet, which
contains formulas, I would like to run a macro to copy and paste the
text only of the the worksheet to another worksheet. I can do this now
before the worksheet is protected but I would like to run the macro
without unptotecting the worksheet.
Thanks--Wally Brockway

 

[Peo Sjoblom]

You have to unprotect the worksheet in the macro, do your thing and then
protect it again A simple example



Application.ScreenUpdating = False

ActiveSheet.Unprotect Password:="abcd"

'Your code here

ActiveSheet.Protect Password:="abcd"

Application.ScreenUpdating = True


End Sub

 

[wally]

Thank you
W a b