I have an excel spreadsheet that opens from the windows scheduler at 1am and runs a process and then it closes. My problem is that I have no way to interrupt the program when I manually open it to be able to modify the VB code. I know that if you have programming in Access that runs on the Application.Activate event that you can stop it by holding down one of the keys while opening the Database (control or Alt or shift, I forget which).
My question is does Excel have a similiar way to stop VB code that runs from the Application.Activate event??? I tried holding down all of those keys that I mentioned above and none of them stop the automatic running of the code from this event. Help!![Roll eyes :rolleyes: :rolleyes:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
My question is does Excel have a similiar way to stop VB code that runs from the Application.Activate event??? I tried holding down all of those keys that I mentioned above and none of them stop the automatic running of the code from this event. Help!