#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LMP LMP is offline
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,489
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default 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.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LMP LMP is offline
external usenet poster
 
Posts: 2
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make this macro stop? Jo[_2_] Excel Worksheet Functions 5 October 4th 07 10:20 PM
Stop macro with userform Jeff Excel Discussion (Misc queries) 1 July 30th 07 02:38 PM
Macro - Stop Recording Phil vK Excel Discussion (Misc queries) 4 May 23rd 07 07:03 PM
How do I stop a Macro from running? JulianB Excel Worksheet Functions 1 April 10th 06 10:33 PM
Macro to stop at a certain tab and does not go to the next one. [email protected] Excel Worksheet Functions 3 March 16th 06 01:11 AM


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"