MrExcel Publishing
Your One Stop for Excel Tips & Solutions

right-click status bar & Macro recording toolbar


Posted by Dennis on October 11, 2000 7:41 AM

1) When I right-click the status bar there is a pop-up menu of "none", "average", "count", etc. (one of which is selected). I can't find a help screen that talks about what this means or does. Does anyone know?
2) When recording macros, I used to have the little toolbar that had the "stop" and "relative" tools on it. I no longer get this toolbar, and I don't know how to make a "relative" macro now. Why did it disappear, and how do I get it back? (I'm just learning macros)
Thanks very much!


Posted by Ben O. on October 11, 2000 8:37 AM

1) That's the autocalculate feature. Look up autocalculate in your help file for more information on it. Basically, it performs the function selected on the active range and displays the result.

I can't help you with your second question. I've never seen that toolbar.

Posted by John L. on October 11, 2000 6:05 PM

Dennis, start recording the macro, then right click on the area
below the horizontal slider bar ( near the bottom of the screeen )
you will see a menu pop up. Select "Stop recording" and the
little toolbar should appear.

Posted by JAF on October 12, 2000 4:07 AM

Dennis

I had the same problem last week. The reason the "little toolbar" disappeared is most likely that when you when you were recording a macro, you accidentally clicked the close button on the toolbar (which inserts the code:Application.CommandBars("Stop Recording").Visible = False) into the macro you were recording at the time.

To get it back, record a "dummy" macro. Once you have started recording, right click on any menu. Just over half way down the list of command bars that appears will be one called "Stop Recording". Left click this and everything will be back to normal.

Hope this helps.


JAF