Macro question in 2007

[Guest]

I recently upgraded to 2007, so I moved\recreated my personal.xls to a a
Macro-enabled workbook (.xlsb). There are two issues now:
1. Excel does not open a blank Book1 when the personal macro file is
hidden. That's a pain b/c i have to go and open a new blank worksheet every
time.
2. When i exit, it only closes the active workbook, not the hidden macro
workbook, so i have to exit twice?

is this a bug or is there something i have to do differently!?

thanks,

 

[Jim Rech]

Try saving it as PERSONAL.XLSM. That is the macro enabled workbook format.
Use the binary format only for large files where loading time is an issue.

--
Jim
|I recently upgraded to 2007, so I moved\recreated my personal.xls to a a
| Macro-enabled workbook (.xlsb). There are two issues now:
| 1. Excel does not open a blank Book1 when the personal macro file is
| hidden. That's a pain b/c i have to go and open a new blank worksheet
every
| time.
| 2. When i exit, it only closes the active workbook, not the hidden macro
| workbook, so i have to exit twice?
|
| is this a bug or is there something i have to do differently!?
|
| thanks,