tobyz95
Board Regular
- Joined
- Jul 28, 2012
- Messages
- 187
Hi ALL, I am looking for some insight on this situation:
I accidently ran a macro I created that copies a new template over the active worksheet..OOPS!
normally/previously I just close without saving..no big deal
this time Excel(2013) doesn't close, and I get the message "Picture too large and will/may be truncated"
can't get rid of it so I have to click "ok", and Excel closes
PROBLEM=when I opened Excel again, it maintained the macro run in error, and I lost the worksheet I had been working on
???? So I went looking for answers on how to "undo a macro run in error" and found two solutions:
1. Close without saving (which I have used previously without problems)
2. Application.OnUndo "Primary Macro", "UndoPrimary" from Alan Wyatt's Excel Tips found here
So now I have a question (of course) Am I suppose to add this to every macro in case I hit it by accident, or maybe just to certain macros, and if so which ones?
As always, any info is greatly appreciated!
I accidently ran a macro I created that copies a new template over the active worksheet..OOPS!
normally/previously I just close without saving..no big deal
this time Excel(2013) doesn't close, and I get the message "Picture too large and will/may be truncated"
can't get rid of it so I have to click "ok", and Excel closes
PROBLEM=when I opened Excel again, it maintained the macro run in error, and I lost the worksheet I had been working on
???? So I went looking for answers on how to "undo a macro run in error" and found two solutions:
1. Close without saving (which I have used previously without problems)
2. Application.OnUndo "Primary Macro", "UndoPrimary" from Alan Wyatt's Excel Tips found here
So now I have a question (of course) Am I suppose to add this to every macro in case I hit it by accident, or maybe just to certain macros, and if so which ones?
As always, any info is greatly appreciated!
