Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dano
 
Posts: n/a
Default Recording new excel macro, relative reference button doesn't show

When recording a new macro in excel I want to select the relative reference
button in the stop recording box, but the stop recording box does not popup;
it's no where to be found. Everything I've read on-line says it just
appears, but it doesn't on my system.

It works fine on my co-workers machine, and he has the same system as mine.
We are both running Windows XP, with excel version 2003.


  #2   Report Post  
FSt1
 
Posts: n/a
Default

hi,
not sure why it isn't popping up on your machine. it does on mine. but you
can access it anyway.

Toolscustomizetoolbar tabcheck stop recording

scroll down....it's near the bottom. you can call it anytime, recording or
not.

regards
FSt1



"Dano" wrote:

When recording a new macro in excel I want to select the relative reference
button in the stop recording box, but the stop recording box does not popup;
it's no where to be found. Everything I've read on-line says it just
appears, but it doesn't on my system.

It works fine on my co-workers machine, and he has the same system as mine.
We are both running Windows XP, with excel version 2003.


  #3   Report Post  
George Gee
 
Posts: n/a
Default


Dano

Start recording a new macro.
Right-click the top toolbar.
Click on 'Stop recording'
The 'Stop recording' toolbar should now appear.

A user probably closed the 'Stop recording' toolbar with the 'X'.
You must be in 'Record New Macro' mode for the 'Stop recording'
menu to be made available.

HTH

George Gee



Dano wrote:
When recording a new macro in excel I want to select the relative
reference button in the stop recording box, but the stop recording
box does not popup; it's no where to be found. Everything I've read
on-line says it just appears, but it doesn't on my system.

It works fine on my co-workers machine, and he has the same system as
mine. We are both running Windows XP, with excel version 2003.



  #4   Report Post  
Dano
 
Posts: n/a
Default

Thank you; that was it. By checking the box in Toolscustomizetoolbar
tabcheck stop recording, the stop recording box, along with the relative
reference button now pops up.

Man, I was really getting frustrated, what an easy fix!

"FSt1" wrote:

hi,
not sure why it isn't popping up on your machine. it does on mine. but you
can access it anyway.

Toolscustomizetoolbar tabcheck stop recording

scroll down....it's near the bottom. you can call it anytime, recording or
not.

regards
FSt1



"Dano" wrote:

When recording a new macro in excel I want to select the relative reference
button in the stop recording box, but the stop recording box does not popup;
it's no where to be found. Everything I've read on-line says it just
appears, but it doesn't on my system.

It works fine on my co-workers machine, and he has the same system as mine.
We are both running Windows XP, with excel version 2003.


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
Macro to close excel okanem Excel Discussion (Misc queries) 1 July 19th 05 10:01 AM
passing arguments from an excel macro to a word macro KWE39 Excel Discussion (Misc queries) 1 July 7th 05 03:56 PM
Excel macro that opens new MS Word file and pastes data as a pictu Rob Excel Worksheet Functions 0 July 6th 05 05:12 PM
Button fails to call macro when open an Excel via Intranet tigertax Excel Discussion (Misc queries) 1 April 12th 05 10:21 AM
Relative Macro Help on Keystrokes Neal Zimm Excel Discussion (Misc queries) 9 December 15th 04 12:31 AM


All times are GMT +1. The time now is 08:03 PM.

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"