Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Disabled Absolute/Relative Macro Button

When I record a new macro, the absolute/relative
reference button does not appear.
How do I re-enable it?



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default Disabled Absolute/Relative Macro Button

With the macro recorder running right-click anywhere in an empty region of
the toolbars and enable (click) the 'Stop Recording' toolbar.

--
Cheers
Nigel



"J Shrimps, Jr." wrote in message
...
When I record a new macro, the absolute/relative
reference button does not appear.
How do I re-enable it?





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Disabled Absolute/Relative Macro Button

???????
How will that make the absolute relative button appear?


"Nigel" wrote in message
...
With the macro recorder running right-click anywhere in an empty region of
the toolbars and enable (click) the 'Stop Recording' toolbar.

--
Cheers
Nigel



"J Shrimps, Jr." wrote in message
...
When I record a new macro, the absolute/relative
reference button does not appear.
How do I re-enable it?







  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default Disabled Absolute/Relative Macro Button

You asked how to do it - this it! - Try it and you will see that next time
you record a macro the toolbar called 'Stop Recording' will appear - the
button to the right on this toolbar is the absolute/relative option.

If you dismiss this toolbar then it will not appear next time you record a
macro - so the absolute/relative button will not be visible again.

As I said try it and see for yourself!


--
Cheers
Nigel



"J Shrimps, Jr." wrote in message
...
???????
How will that make the absolute relative button appear?


"Nigel" wrote in message
...
With the macro recorder running right-click anywhere in an empty region

of
the toolbars and enable (click) the 'Stop Recording' toolbar.

--
Cheers
Nigel



"J Shrimps, Jr." wrote in message
...
When I record a new macro, the absolute/relative
reference button does not appear.
How do I re-enable it?









  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 349
Default Disabled Absolute/Relative Macro Button

Nigel,

Thank you for the fix! What a weird deal....one day it was there,
then....gone. Not too worried about the why, just am thankful that it's back.

Peter
--
Have a great day everyone!


"Nigel" wrote:

You asked how to do it - this it! - Try it and you will see that next time
you record a macro the toolbar called 'Stop Recording' will appear - the
button to the right on this toolbar is the absolute/relative option.

If you dismiss this toolbar then it will not appear next time you record a
macro - so the absolute/relative button will not be visible again.

As I said try it and see for yourself!


--
Cheers
Nigel



"J Shrimps, Jr." wrote in message
...
???????
How will that make the absolute relative button appear?


"Nigel" wrote in message
...
With the macro recorder running right-click anywhere in an empty region

of
the toolbars and enable (click) the 'Stop Recording' toolbar.

--
Cheers
Nigel



"J Shrimps, Jr." wrote in message
...
When I record a new macro, the absolute/relative
reference button does not appear.
How do I re-enable it?










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
Recording Macro, toggle absolute/relative reference, button disapp Kayos Excel Programming 2 October 18th 05 08:42 PM
How do I get relative/absolute reference button (macros) SPBaku Excel Discussion (Misc queries) 1 May 27th 05 02:18 PM
macro to copy absolute cells, then paste relative Bill Carr Excel Programming 1 November 16th 04 10:42 PM
record macro - copy absolute, paste relative Bill Carr Excel Programming 0 October 27th 04 10:41 PM
missing macro absolute/relative referencing toolbar Alex[_20_] Excel Programming 2 March 2nd 04 05:48 PM


All times are GMT +1. The time now is 08:47 AM.

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

About Us

"It's about Microsoft Excel"