protection problem

[Robert Lee]

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
..

 

[Dave Peterson]

See one response at your first post.

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
.