ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   personal workbook (https://www.excelbanter.com/excel-discussion-misc-queries/52295-personal-workbook.html)

afdmello

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

AFD



Bob Phillips

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





afdmello

personal workbook
 
Thank you it helped me immensely

AFD




All times are GMT +1. The time now is 04:41 PM.

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