ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Relative Macros (https://www.excelbanter.com/excel-programming/290010-excel-relative-macros.html)

llockler

Excel Relative Macros
 
I recently closed my popup window for macros in Excel 2002. Now I can't
get it back. I like to record macros using the relative button on that
popup, and I can't find this button on any of the tool bars.

Anybody know how I can get this popup back? Or find a
relative/absolute button to put on my tool bar?


---
Message posted from http://www.ExcelForum.com/


Ron de Bruin

Excel Relative Macros
 
Answer from Tom Ogilvy on this problem

Start recording a macro, then right click on a blank area of a toolbar and
select the stop recording toolbar.
(or use View=Toolbars from the menu)
then click the stop button.

Now when you record, the button will appear. Don't click the x to hide it
when recording or you will have to repeat the above.


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"llockler " wrote in message ...
I recently closed my popup window for macros in Excel 2002. Now I can't
get it back. I like to record macros using the relative button on that
popup, and I can't find this button on any of the tool bars.

Anybody know how I can get this popup back? Or find a
relative/absolute button to put on my tool bar?


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com