protecting a workbook but still able to run macros

is it possible to protect a workbook but still run various macros, i have tried this and the macros wont run

that was almost exactly what i wanted, i still needed to do a bit more research and messing around to get it working right but have now got exactly the workbook result i needed

thank you

is there a way to change the password in this macro, every time i try i get an error message saying i've entered the wrong password. i tried changing the code and putting it in a new workbook and it worked ok, but it wont let me change it in an existing workbook

managed a workaround by creating a new workbook and copying all the sheets from the old one with protection turned off, then re-applying the macro with a new password on the new sheet, needed quite a bit of work but problem solved. thanks. would still love to know why i couldnt just change the password on the original workbook though, it's a puzzle

This is a great bit of code. Is it possible to hide the password in the code or prevent them going into it, as want to prevent users from unprotecting the work sheet?

Thanks
Harry

havent found a way to hide the password but if you go to the vba editor, click on tools, VBAprojectproperties and select the protection tab. tick the "lock for viewing" box and enter the same password, no one without the password can see or change the macros, including the protection. works perfectly