Book1 is gone

[Mani_PL]

Hi,

I had the problem of Pivot toolbar disappearing evertime I
opened excel. So, I saved a blank Book1 with pivot table
toolbar and other toolbars which i used often selected, as
Personal.xls.

But to my horror i find that everytime I open excel, I get
Personal.xls opening instead of just Book1. And if I open
some other file, the personal.xls file still appears and
does not go away, which is not the case normally. Could
somebody help me where I made the mistake.

Thanks,
Mani

 

[Gord Dibben]

Personal.xls is your global macro workbook.

For help on setting up a default workbook see help on "Templates".

You will create a new workbook formatted as you wish then save it as BOOK.XLT
in your XLSTART folder.

As far as Toolbar settings, they are saved in your *.XLB file

To not see Personal.xls open up, you can remove it from the XLSTART folder or
just hide it when open, save and it will open hidden from now on.

Gord Dibben Excel MVP

 

[Dave Peterson]

Maybe you could just a few lines to your personal.xls auto_open code to show the
toolbars you want to see:

Like:

Application.CommandBars("Pivottable").Visible = True

 

[Mani _PL]

Hello Gord,

Thanks a lot for the info. I was able to restore book1 and
personal.xls is now hidden. It is such a simple thing, but
excel's help menu does not have any info on this. Anyway,
thanks a lot once again.

Regards,
Mani

 

[Gord Dibben]

Mani

See Dave Peterson's suggestion also for Toolbar settings.

Gord