VBA Memory jog!

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
 
B

BrianB

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Object Browser in VBA 0
Need Help with a VBA subroutine 0
Handling internet explorer memory leaks from Excel VBA 0
Limit (not memory) consumed by Range Names, UDF calls, VB code, st 0
Unexpected internal error or not enough memory 1
Excel 2003 with VBA - "Can't find project or library" 6
clearing memory using VBA 1
Excel 2007 VBA and Text Boxes 2

Top