ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Macro Stop (https://www.excelbanter.com/excel-worksheet-functions/185135-macro-stop.html)

LMP

Macro Stop
 
When you start a Macro there is a small window that comes up that allows you
to stop the macro and choose relative or absolute reference. Mine has
disappeared. Our IT guys have worked and worked on this to no avail. They
have even reinstalled Outlook & Excel. Still the same issues. I was hoping
this group might have suggestons.

Thanks in advance for your help.

Andy Pope

Macro Stop
 
Hi,

You could try this in your immediate window, (ALT+F11 then CTRL+G), which
should show the toolbar.

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

You might also check the Left and Top properties to make sure it is within
monitors view.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"LMP" wrote in message
...
When you start a Macro there is a small window that comes up that allows
you
to stop the macro and choose relative or absolute reference. Mine has
disappeared. Our IT guys have worked and worked on this to no avail. They
have even reinstalled Outlook & Excel. Still the same issues. I was hoping
this group might have suggestons.

Thanks in advance for your help.



Bob Phillips

Macro Stop
 
This is how I do it


Start recording another macro, then goto ToolsCustomise and select the
Toolbars tab, then check the Stop Recording checkbox


And don't close it by hitting the "X" when recording a macro or you will
lose it again.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"LMP" wrote in message
...
When you start a Macro there is a small window that comes up that allows
you
to stop the macro and choose relative or absolute reference. Mine has
disappeared. Our IT guys have worked and worked on this to no avail. They
have even reinstalled Outlook & Excel. Still the same issues. I was hoping
this group might have suggestons.

Thanks in advance for your help.




LMP

Macro Stop
 
Bob Thanks. This was perfect. LMP

"Bob Phillips" wrote:

This is how I do it


Start recording another macro, then goto ToolsCustomise and select the
Toolbars tab, then check the Stop Recording checkbox


And don't close it by hitting the "X" when recording a macro or you will
lose it again.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"LMP" wrote in message
...
When you start a Macro there is a small window that comes up that allows
you
to stop the macro and choose relative or absolute reference. Mine has
disappeared. Our IT guys have worked and worked on this to no avail. They
have even reinstalled Outlook & Excel. Still the same issues. I was hoping
this group might have suggestons.

Thanks in advance for your help.






All times are GMT +1. The time now is 06:42 PM.

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