#1   Report Post  
afdmello
 
Posts: n/a
Default personal workbook

What is this workbook?where is it located?how do I open it ?why is it used
for?

AFD


  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default personal workbook

It is located in the XLStart directory, and is used to store macros an d
things that you want to be available to all workbooks, whenever you start
Excel.

You can create it b y
- goto ToolsMacrosRecord New Macro...
- Choose Personal Macro Workbook form thr dropdown
- OK
- click the Stop button on the toolbar that pops-up

You now have a Personal.xls workbbok. It is not visible though, it is hidden
by default (WindowsUnhide)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"afdmello" wrote in message
...
What is this workbook?where is it located?how do I open it ?why is it used
for?

AFD




  #3   Report Post  
afdmello
 
Posts: n/a
Default personal workbook

Thank you it helped me immensely

AFD


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
Strange Personal Macro Workbook Behavior stretch Excel Discussion (Misc queries) 4 August 4th 05 07:39 PM
Personal MAcro workbook in Excel 2003 Misha Excel Discussion (Misc queries) 1 July 11th 05 07:48 AM
Personal macro workbook and personal.xls John Kilkenny Excel Discussion (Misc queries) 1 June 14th 05 09:43 PM
Personal workbook opens when Excel opens SheriTingle Excel Discussion (Misc queries) 2 March 30th 05 12:22 AM
Unprotect Workbook Kent Excel Discussion (Misc queries) 1 February 4th 05 01:07 AM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"