Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
VBA memory | Excel Discussion (Misc queries) | |||
Not Enough Memory | Excel Discussion (Misc queries) | |||
Vba Memory | Excel Discussion (Misc queries) | |||
Out of Memory | Excel Discussion (Misc queries) |