Protected sheets and running macros

R

robert_woodie

i have a sheet with a macro ran by a normal button at the top. Howeve
when i protect the worksheet where ever i click on the sheet the macr
executes.

Can any one offer any advice on how to stop this?

Thanks
Robert
 
I

icestationzbra

hi,

i am not able to reproduce the problem, hence i may not be able t
provide a panacea for that issue.

here is what i suggest.

i have a sheet that has a macro that is run when a control toolbo
button (that is, not a form button) is clicked.

this sheet is protected based on the user logged in. what i have don
is to protect the button through another macro. this button become
disabled, hence it does not run the macro when clicked on.

mac
 
Top