ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Recording Macro's Mini Floating Toolbar (https://www.excelbanter.com/excel-discussion-misc-queries/150778-recording-macros-mini-floating-toolbar.html)

wurth51

Recording Macro's Mini Floating Toolbar
 
I 've lost the "mini" floating toolbar that pops up when you select to record
a macro while is a spreadsheet. The toolbar offers a "stop recording" button
and a "relative" reference button. Any ideas how to get this toolbar to come
back when I go into Macro Record mode? I'm using Excel 2003, standard
worksheet. Had the floating toolbar yesterday.

Bob I

Recording Macro's Mini Floating Toolbar
 
R-click Toolbar area, Customize, and put a tick in "Stop Recording"

wurth51 wrote:
I 've lost the "mini" floating toolbar that pops up when you select to record
a macro while is a spreadsheet. The toolbar offers a "stop recording" button
and a "relative" reference button. Any ideas how to get this toolbar to come
back when I go into Macro Record mode? I'm using Excel 2003, standard
worksheet. Had the floating toolbar yesterday.



wurth51

Recording Macro's Mini Floating Toolbar
 
Thanks Bob I,

I didn't find a "Stop Recording" listed when I R-Clicked the toolbar,
however, I did go to "customize" : "Toolbars" and found it there. So I was
able to put it in the toolbars above (permanently). Not sure why the
"floating" mini toolbar got hosed but this works fine. Again, thanks.

"Bob I" wrote:

R-click Toolbar area, Customize, and put a tick in "Stop Recording"

wurth51 wrote:
I 've lost the "mini" floating toolbar that pops up when you select to record
a macro while is a spreadsheet. The toolbar offers a "stop recording" button
and a "relative" reference button. Any ideas how to get this toolbar to come
back when I go into Macro Record mode? I'm using Excel 2003, standard
worksheet. Had the floating toolbar yesterday.




Jim Thomlinson

Recording Macro's Mini Floating Toolbar
 
When you start rcording a macro Excel Unhides the toolbar. When you hit stop
recording it hides the toolbar. If instead of hitting stop you hit the x then
it removes the toolbar. Note that removing is very different from hiding. The
next time you record a macro and hit stop it will once again hide the
toolbar.
--
HTH...

Jim Thomlinson


"wurth51" wrote:

Thanks Bob I,

I didn't find a "Stop Recording" listed when I R-Clicked the toolbar,
however, I did go to "customize" : "Toolbars" and found it there. So I was
able to put it in the toolbars above (permanently). Not sure why the
"floating" mini toolbar got hosed but this works fine. Again, thanks.

"Bob I" wrote:

R-click Toolbar area, Customize, and put a tick in "Stop Recording"

wurth51 wrote:
I 've lost the "mini" floating toolbar that pops up when you select to record
a macro while is a spreadsheet. The toolbar offers a "stop recording" button
and a "relative" reference button. Any ideas how to get this toolbar to come
back when I go into Macro Record mode? I'm using Excel 2003, standard
worksheet. Had the floating toolbar yesterday.




wurth51

Recording Macro's Mini Floating Toolbar
 
Jim, Thanks, I didn't realize the difference. I do recall finding out
yesterday that I was still recording a macro when I thought I had stopped it.
However, now that I have hit the 'x' and removed it, how do I get it to come
back when I start recording a macro again? Right now I am doing what Bill
suggested and "customizing" my toolbar to show these buttons at all times.

"Jim Thomlinson" wrote:

When you start rcording a macro Excel Unhides the toolbar. When you hit stop
recording it hides the toolbar. If instead of hitting stop you hit the x then
it removes the toolbar. Note that removing is very different from hiding. The
next time you record a macro and hit stop it will once again hide the
toolbar.
--
HTH...

Jim Thomlinson


"wurth51" wrote:

Thanks Bob I,

I didn't find a "Stop Recording" listed when I R-Clicked the toolbar,
however, I did go to "customize" : "Toolbars" and found it there. So I was
able to put it in the toolbars above (permanently). Not sure why the
"floating" mini toolbar got hosed but this works fine. Again, thanks.

"Bob I" wrote:

R-click Toolbar area, Customize, and put a tick in "Stop Recording"

wurth51 wrote:
I 've lost the "mini" floating toolbar that pops up when you select to record
a macro while is a spreadsheet. The toolbar offers a "stop recording" button
and a "relative" reference button. Any ideas how to get this toolbar to come
back when I go into Macro Record mode? I'm using Excel 2003, standard
worksheet. Had the floating toolbar yesterday.



Bob I

Recording Macro's Mini Floating Toolbar
 
You're welcome, please be aware that the step after r-clicking toolbar
is selecting "Customize". ;-)


wurth51 wrote:

Thanks Bob I,

I didn't find a "Stop Recording" listed when I R-Clicked the toolbar,
however, I did go to "customize" : "Toolbars" and found it there. So I was
able to put it in the toolbars above (permanently). Not sure why the
"floating" mini toolbar got hosed but this works fine. Again, thanks.

"Bob I" wrote:


R-click Toolbar area, Customize, and put a tick in "Stop Recording"

wurth51 wrote:

I 've lost the "mini" floating toolbar that pops up when you select to record
a macro while is a spreadsheet. The toolbar offers a "stop recording" button
and a "relative" reference button. Any ideas how to get this toolbar to come
back when I go into Macro Record mode? I'm using Excel 2003, standard
worksheet. Had the floating toolbar yesterday.






All times are GMT +1. The time now is 04:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com