![]() |
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. |
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. |
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. |
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