OK. I appreciate your replies. I guess it must be a communications thing. My macro code really has nothing do do with my inquiry. I only used the macro and what I was experiencing, as an example to show or explain what I would like do.
So, just assume I had not mentioned my macro at all, or what it was doing. Now, is there any way to code the following procedure: (I would like to be able to execute the following steps, preferrably with a macro rather than having to do the steps manually).
From Excel:
1. Click Tools
2. Point at Macro
3. Click Visual Basic Editor
4. In the VBA Editor menus, Click the Run menu
5. In the drop-down, Click the Reset command
6. Return to Excel
Or, any other macro execution which would "do what steps 1-6 do". Turning the Macro Recorder ON does not record anything when I do those steps. And, if you just do steps 1-6, it appears that you have done nothing. However, I can assure you, something in Excel gets reset because when I manually do those steps, Excel makes a "distinct" change (I can see it in the execution time of my macro).
Microsoft would not have the VBA Run/Reset command in the menu if it didn't do something. It may not be possible to code it but Excel recognizes when you click Reset. That's all I'm asking. Is it possible to execute that Reset with code (or anything else equivalent in code) rather than having to manually click thru the steps?
Thanks for your help.
JerryD