ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Record Macro Window. (https://www.excelbanter.com/excel-programming/410706-record-macro-window.html)

Heera

Record Macro Window.
 
Hi,

I cannot see the small window which pop's up when we select record
macro from the option toolsMacro

Can any one help tell me to to get it back so that i can record the
macro with or without refrence mode.

Regards

Heera

Gary''s Student

Record Macro Window.
 
View Toolbars Customize Toolbars and check Stop Recording

or put the following line in a macro and run it:

Application.CommandBars("Stop Recording").Visible = True

--
Gary''s Student - gsnu200785


"Heera" wrote:

Hi,

I cannot see the small window which pop's up when we select record
macro from the option toolsMacro

Can any one help tell me to to get it back so that i can record the
macro with or without refrence mode.

Regards

Heera


Jim Thomlinson

Record Macro Window.
 
Tools - Customize - Toolbars tab - check Stop Recording Macro
This will bring up the toolbar. Record any macro and click stop on the
toolbar. This will hide the toolbar. Don't click the X. That disables the
toolbar and keeps it from appearing when you record macros.
--
HTH...

Jim Thomlinson


"Heera" wrote:

Hi,

I cannot see the small window which pop's up when we select record
macro from the option toolsMacro

Can any one help tell me to to get it back so that i can record the
macro with or without refrence mode.

Regards

Heera


Heera

Record Macro Window.
 
Gary & Jim Thank you.

That was a great help.....


All times are GMT +1. The time now is 06:23 AM.

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