Hi,

I have a worksheet I need to have protected, and when I run code to restore
cell format, I unprotect it temporary. However, this causes clipboard to
turn empty and since I run the code both at worksheet_activate and
worksheet_change events, the result is that you can't copy-paste between
sheets.

At line below, the clipboard turn empty ...
"Application.Worksheets(XshtName).UnProtect Password:=sPass"

1/ Is there a way to work around this and still use the code both at
worksheet_change and worksheet_activate?
2/ The reason why I have it on worksheet_activate is because I want to
restore cell formats when drag and drop occure from other sheets - - it
doesn't trig the worksheet_change event, I'm told. Right? Workaround?


/Kind regards