petunia, you could unprotect the sheet run your code and then protect the
sheet like this

ActiveSheet.Unprotect password:="123"

'you code here

ActiveSheet.Protect password:="123"



or protect it with user interface only, like this then the macros will run,
this will have to be set each time the workbook is opened

ActiveSheet.Protect UserInterfaceOnly:=True, password:="123"
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"petunia" wrote in message
...

I have a macro in a protected workbook that won't work correctly with it
protected, how can I get the macro's to work