How do you debug on start up?

[reneuend]

I need to be able to debug an error that occurs when the workbook first opens. The problem is that I don't get an option to "debug". Is there a way to stop the code in my macro when the workbook first opens?

I tried using "stop", but it treated it like a comment and went right past it.

- Excel 2003
- Windows XP

All comments are very much appreciated!

 

[Smitty]

Can you post your code and indicate where it's bombing?

You might want to take a look here: http://www.cpearson.com/excel/ErrorHandling.htm

 

[reneuend]

Hi Smitty,

Thanks for the reply.

I'm not able to post the code due to corporate policy, but the error I'm receiving is a "Runtime Error 1004: Application-Defined or Object-Defined Error" when I first open the workbook. There is a lot of code that runs upon opening the workbook, but this error started occuring when I integrated some worksheets from another workbook that had numerous named references. I had to go through the named references and change their locations to use this workbook. I also removed a lot of dead named references while I was at it. I'm guessing that maybe there is a call to a named-reference that no longer exists.

If there was a way to stop the code when it first opens the workbook so I can go into debug mode, then I could step through it and find where the issue is occuring. Do you know a way to do this?


(edit) I used "On Error" routine to try to bypass the error when the error was a 1004, but I feel like this might come back to bite me later.




Thanks!

 

[Smitty]

Fortunately, you can actually step through the Open event. Just use F8 and that will walk you through the code line-by-line.

 

[reneuend]

I figured it out. My call to "stop" in the workbook_open routine wasn't working because I had the vba code password protected. Once I turned off the protection, I was able to stop the code upon opening the workbook and step to where the error occurred.

Thanks for spending time with me, Smiitty. Much appreciated.

 

[Smitty]

Sorry, I should have asked if you had protected the project.