ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   What is a "Personal Workbook" in Excel? (https://www.excelbanter.com/new-users-excel/34653-what-%22personal-workbook%22-excel.html)

Michael-OK

What is a "Personal Workbook" in Excel?
 
While creating a macro in Excel 2000, was given the option to save to a
"Personal Workbook". Cannot find in 'Help' any explanation for just what a
"Personal Workbook" is and what one would do with it!

VoG via OfficeKB.com

Does this help http://www.personal-computer-tutor.com/personalxls.htm


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200507/1

Bob Phillips

Personal.xls is a 'special' workbook that is stored in the Excel startup
directory. Because of this, it is loaded every time that Excel starts, it is
always there, but you wouldn't know as it is hidden (you can see it if you
go to menu WindowsUnhide).

It tends to be used to store macros that you want to be generally available,
such as macros that you assign to custom toolbar buttons, or to build extra
menus.

--
HTH

Bob Phillips

"Michael-OK" wrote in message
...
While creating a macro in Excel 2000, was given the option to save to a
"Personal Workbook". Cannot find in 'Help' any explanation for just what

a
"Personal Workbook" is and what one would do with it!





All times are GMT +1. The time now is 01:31 PM.

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