Windows Forum

Ask something
Discussion Locked

Excel 97 : toolbars disappeared

0 helpful
5 replies

by nagazaki

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

No more toolbars in excel97 after opening a spreadsheet containing macros.

I resolved the same problem with Excel 2000 by deleting the excel.xlb file, but don't know what file to delete for the 97 version.

People talk about book.xlt in XLSTARTbut no way.

Help would be appreciated

5 replies

by don christner

Can't you just click VIEW and then TOOLBARS from the menu and just add the toolbars that you want displayed? Or am I missing something?

Don

by nagazaki

You're just missing that I said that there were no more toolbars, even the one containing files, edit ...

but thanks :)

by jmiller1

On a working machine, create a new workbook. Click on Tools->Macro->VB Editor. Paste this code into the Workbook_Open function:

Application.Dialogs(xlDialogCustomizeToolbar).Show

Save and close the workbook. Open the workbook on the broken machine. When the menu comes up, place a check in 'Worksheet Menu Bar' and apply and your menus will be back.

jm

by nagazaki

Look like interesting, but where is that Workbook_Open function ? Do I have to create it ? I need some more explanations thxs.

This discussion is closed to new replies.