I do not believe this site allows an entire workbook to be posted. You
would have to save the workbook to a sharepoint sever and then reference the
file in a post on this site. But you should be able to open the VBE and
copy the portion of the macro that you are having trouble with, and then
copy and paste that to this this site. Perhaps you are not familiar with
how that works.



"Isis" wrote in message
...
"Per Jessen" wrote in
:

Hi

As always post the code for comments.

Well, as the code run when the sheet is unprotected, I guess that your
code is trying to trying to change one or more cells in the protected
sheet, which it can not.

The solution is to unprotect the sheet by code, then change cells and
protect it again

sub MyMacro
Worksheets("Sheet1").unprotect Password:="JustMe"

'Your Code

Worksheets("Sheet1").Protect Password:="JustMe")
End Sun

Regards,
Per

"Isis" skrev i meddelelsen
...
I have a sheet that seems to get 'stuck' calling a block of non
existent code - it happens after I clear the sheet then click any of
a number of cells.

It has something to do with protection as it does not happen if I
unprotect
the sheet - obviously noone is going to be able to pinpoint this from
a short description !

How can I find the reference to the the non existent code block in my
code - I have done a 'find' within the code but I am not seeing it ?

Any other ideas would be most welcome.

Thanks



Per, thanks very much for the reply - I don't think I can post the code,
there is a lot of it, but I could post the entire workbook if that is
allowed ?

I realised that the problem is the locked/unlocked status of the cells,
but the block of code being called does not exist as far as I can tell -
the name that comes up does not exist that to to say.

Anyhow, if it's ok to post the workbook I will ? Should I zip it
beforehand ?

Thanks