How are you going to disable macros by running a macro ???
It's all a bit pointless because you can't set the protection level of a workbook by code - if you could, there would be no point having macro protection in the 1st place !
Rgds, Geoff
"Three things are certain: Death, taxes and lost data. Guess which has occurred"
Please read FAQ222-2244 before you ask a question