hello,

how to get stop recording macro toolbar? as i have to set relative reference
instead of absolute reference in macro.

thanks in advance

hi,
toolscustomizetoolbar tab
Scroll down and check Stop recording.
click ok

Regards
FSt1

"Ankur" wrote:

hello,

how to get stop recording macro toolbar? as i have to set relative reference
instead of absolute reference in macro.

thanks in advance

Good afternoon Ankur

Go to Tools Macro Record new macro. Once it is recording right
click on your toolbar at the top and look at all the toolbars
available. One should say Stop Recording. Select this and then click
on the stop recording button. The next time you come to record a macro
the toolbar will open automatically.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=399477

Thank Goodness!!!! I've spent about an hour, closing the file, the program,
reopening and trying to find this in "help". All because when the toolbar
greyed out while recording to stop recording I closed it by clicking on the
"X" close button - and it still didnt stop recording :-(.
Thanks fellas.




"dominicb" wrote:


Good afternoon Ankur

Go to Tools Macro Record new macro. Once it is recording right
click on your toolbar at the top and look at all the toolbars
available. One should say Stop Recording. Select this and then click
on the stop recording button. The next time you come to record a macro
the toolbar will open automatically.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=399477