Protection of workbook and worksheet

Hi everyone

I have a workbook I wanted to protect. So I protected the workbook with a password via the tab "Review". However when I saved it and re opened it, the macros were disable and I could not enable them since in the pop up window Security Alert, the case "enable macro" disappeared leaving me with only one option : "help protect me from unknown contents", even though in the macro settings, all macros are enabled. After entering the password it works, but I don't want to give away my password to the user to use it hihihi

So how can I protect my workbook and worksheets from being deleted/renamed and but still be able to play with the macros?

Thanks a lot for your help

Susie

Hi romperstomper !

thanks for the link, I will have a look at it

Susie