Excel with Macros

  • Thread starter Thread starter Rajesh
  • Start date Start date
R

Rajesh

I have protected a worksheet with macros and when I try an
run them I get "run time error 1004" I need to able to
protect the sheet from alterations by others. What is the
error and how do I fix it?

regds
 
Hi
depending on the macro actions you may have to unprotect the sheet at
the beginning of your macro and protect it again at the end of the run
 
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

Excel 2007: Help creating a macro that will run Solver? 3
protection and changing formulas 3
problem with macros and protections 5
Excel Macros in 2007 6
run time error 1004 for other user 1
Error in Macro 2003 2
Starting Auto_Close macro based on an IF statement 4
Excel - randomly locking cells? 6

Back
Top