VBA Memory jog!
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

VBA Memory jog!
 

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
===========================================


Gary J wrote in message ...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/