Hi guys
I'm hoping someone can help me, I've got some code which runs perfect (from button click) but I need to password protect the sheet so no one fiddles oops I mean changes anything.
Problem is when the sheets are protected the vba doesn't run? VBA on one sheet will populate cells on another.
I have done this vba for one sheet and it works
So I modified it to run on all sheet names and it fails? Any ideas?
Thanks in advance guys.
I'm hoping someone can help me, I've got some code which runs perfect (from button click) but I need to password protect the sheet so no one fiddles oops I mean changes anything.
Problem is when the sheets are protected the vba doesn't run? VBA on one sheet will populate cells on another.
I have done this vba for one sheet and it works
VBA Code:
Sheets("CustomerService").Unprotect "Pete"
MY CODE HERE
Sheets("CustomerService").Protect "Pete"
So I modified it to run on all sheet names and it fails? Any ideas?
VBA Code:
Sheets("PCD" , "Sales", "PCDPlanning", "CustomerService1").Unprotect "Pete"
MY CODE HERE
Sheets("PCD" & "Sales" & "PCDPlanning" & "CustomerService1").Protect "Pete"
Thanks in advance guys.