Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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

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
Personal Macro workbook BillD Excel Discussion (Misc queries) 2 October 19th 07 04:39 PM
Personal Macro Workbook Vision2279 Excel Worksheet Functions 1 November 22nd 06 03:40 PM
Personal Macro Workbook Frustrated Excel Discussion (Misc queries) 2 August 17th 06 04:45 AM
Where is Personal Macro Workbook? fxcel Excel Discussion (Misc queries) 2 June 17th 06 02:26 PM
Personal macro workbook and personal.xls John Kilkenny Excel Discussion (Misc queries) 1 June 14th 05 09:43 PM


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