ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Personal Macro Workbook (https://www.excelbanter.com/excel-discussion-misc-queries/168537-personal-macro-workbook.html)

Chilvers

Personal Macro Workbook
 
I created a macro and stored it in "Personal Macro Workbook"
I now want to edit that macro... where do I find the "Personal Macro Workbook"
thanks

Ron de Bruin

Personal Macro Workbook
 
Hi Chilvers

Alt F11 to go to the VBA editor
Ctrl r
Select you personal.xls
Press this key one time * (numeric keyboard)
Double click on Module1 and edit the code

See also this page
http://www.rondebruin.nl/personal.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chilvers" wrote in message ...
I created a macro and stored it in "Personal Macro Workbook"
I now want to edit that macro... where do I find the "Personal Macro Workbook"
thanks



All times are GMT +1. The time now is 10:49 PM.

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