What is a "Personal Workbook" in Excel?

M

Michael-OK

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!
 
B

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 Windows>Unhide).

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top