General discussion

Locked

Excel 97 : toolbars disappeared

By NaGaZaKi ·
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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel 97 : toolbars disappeared

by Don Christner In reply to Excel 97 : toolbars disap ...

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

Collapse -

Excel 97 : toolbars disappeared

by NaGaZaKi In reply to Excel 97 : toolbars disap ...

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

but thanks :)

Collapse -

Excel 97 : toolbars disappeared

by jmiller1 In reply to Excel 97 : toolbars disap ...

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

Collapse -

Excel 97 : toolbars disappeared

by NaGaZaKi In reply to Excel 97 : toolbars disap ...

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

Collapse -

Excel 97 : toolbars disappeared

by NaGaZaKi In reply to Excel 97 : toolbars disap ...

This question was closed by the author

Back to Windows Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums