0

I have a VBScript Macro being run from MS Excel 2007. 5 minutes ago, when I debugged, if the code made changes to the excel doc that was open, I could see those changes in real time as I stepped through the code. All of a sudden, I don't see most of the changes in the Excel file.

Improve this question
4
  • VBScript or VBA? Care to show us the code so we have some sort of a chance? Commented Aug 12, 2011 at 6:17
  • It's VBScript, I'm pretty sure. Commented Aug 12, 2011 at 18:41
  • Why not 100% sure? Care to show us? Commented Aug 13, 2011 at 10:34
  • When the excel file stops being updated do ctrl+break to enter debug mode. Inspect. Especially screen updating. Commented Aug 7, 2015 at 12:54

1 Answer 1

Reset to default
4

Have you perhaps set Application.ScreenUpdating to False?

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

I have not set Application.ScreenUpdating to anything, and all of a sudden the excel file is updating again. Not sure why.It's VBScript, I'm pretty sure.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.