Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make this macro stop? | Excel Worksheet Functions | |||
Stop macro with userform | Excel Discussion (Misc queries) | |||
Macro - Stop Recording | Excel Discussion (Misc queries) | |||
How do I stop a Macro from running? | Excel Worksheet Functions | |||
Macro to stop at a certain tab and does not go to the next one. | Excel Worksheet Functions |