UserInterfaceOnly

R

RobertLee

I am protecting a worksheet with UserInterfaceOnly set to
true so VBA can change cells. I am not adding any objects.
When I try to run the macro I get a runtime error 1004.
Cannot change protected cells. I am also using on action
to make a custom toolbar. Would that cause the error? Any
suggestions around it instead of turning off protection
before the cell is overridden
 
D

Dave Peterson

There are some things that you can't do via a macro even with UserInterfaceonly
set to true.

Maybe you're doing one of those????

You may want to post your code and indicate the offending line.
 
Top