MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro quit running!

Posted by Nicole on April 30, 2001 7:14 AM

I have created a macro in a worksheet, then when running right will insert four preformatted lines of information. I just when in there and rewrote the code to unprotect the worksheet before it inserts the rows of information and then reprotect it afterwards. Problem is, now it only inserts the first row of data!! What happened?

Posted by Dave Hawley on April 30, 2001 7:17 AM

Hi Nicole

Very hard to say "what happened" without seeing the applicable piece of Code. However it is unlikely that using Code to UnProtect and then Protect the sheet is causing this.


OzGrid Business Applications