ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Visual Basic Tool Bar (https://www.excelbanter.com/excel-programming/332413-visual-basic-tool-bar.html)

Arturo

Visual Basic Tool Bar
 
Hi -
Seemingly I have dismissed a two button floating tool bar that would appear
floating when recording a macro. How do I get that back?

Arturo

Ron de Bruin

Visual Basic Tool Bar
 
Hi Arturo

Start recording a macro
Right click on a commandbar and check the Stop recording
OK to stop the recording
Delete the macro




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Arturo" wrote in message ...
Hi -
Seemingly I have dismissed a two button floating tool bar that would appear
floating when recording a macro. How do I get that back?

Arturo




Bernie Deitrick

Visual Basic Tool Bar
 
Arturo,

Sub Macro1()
With Application.CommandBars("Stop Recording")
..Visible = True
..Enabled = True
End With
End Sub

HTH,
Bernie
MS Excel MVP


"Arturo" wrote in message
...
Hi -
Seemingly I have dismissed a two button floating tool bar that would

appear
floating when recording a macro. How do I get that back?

Arturo





All times are GMT +1. The time now is 02:55 AM.

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