VBA Memory jog!

  • Thread starter Thread starter Gary J
  • Start date Start date
G

Gary J

When using Excel 4 I was able to take a VB snap shot of the users screen
setup options and then reinstate them when exiting from my workbook,
but I forget how. I'm now using Excel (Office XP) and need to perform
the same actions on some new workbooks, can anyone help?

Gary J
 
You need to read setup options (depending on which ones your macro
changes) on starting the macro and reset them at the end.
eg. Start : MyCalc=Application.Calculation, Finish :
Application.Calculation =MyCalc


Regards
BrianB
===========================================
 
Back
Top