protection problem

  • Thread starter Thread starter Robert Lee
  • Start date Start date
R

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
..
 
See one response at your first post.


Robert said:
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
.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modifying a protect unprotect macro 10
Grouping with protected sheets (multiple sheets) 0
protected cells can be deleted?! 7
How to protect sheet allowing grouping and ungrouping but alsoallowing changing colour of specific c 2
modify macro to include more tabs 1
CHANGING POSITION OF AUTOFILTER LIST 4
Filtering a protected WS in a shared workbook - Excel 2000 3
Where do I add this Macro 3

Back
Top