Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Macro relative reference toolbar disappeared

I've been recording some macros, using the built-in recorder; however, now
the miniature toolbox that lets you set for relative references and stop
recording has vanished. How do I retrieve? (XL 2003) TIA


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Macro relative reference toolbar disappeared

That happens when you are recording a macro and close the toolbar by
clicking on the "X" instead of clicking on the stop recording button.

One way to get it back:

Right click any toolbar
Select CustomizeToolbarsStop recording
Since you're not recording at this time it's OK to close it using the "X".

The next time you do record it'll show up. Just remember to use the stop
recording button or you'll have to go through this again!

Biff

"Fred" wrote in message
...
I've been recording some macros, using the built-in recorder; however, now
the miniature toolbox that lets you set for relative references and stop
recording has vanished. How do I retrieve? (XL 2003) TIA



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
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 05:12 PM
How to stop Excel remembering/loading macro from previously opened Workbook Norman Yuan Excel Discussion (Misc queries) 4 June 17th 06 04:13 PM
Circular reference toolbar not working [email protected] Excel Discussion (Misc queries) 3 May 29th 06 01:55 AM
Rookie at linking - need a tudor!!! The Smuffer Excel Worksheet Functions 9 March 7th 06 08:04 PM
Relative Cell position NOT working with or without macro Scratching my Head Excel Discussion (Misc queries) 6 May 30th 05 06:12 PM


All times are GMT +1. The time now is 11:07 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"