i have lost the File option on the top list on my excel spreadshe

G

Guest

I am having a problem on my Excel spreadsheets. On the top list the File
option is gone. Edit, View, Insert, Format, Tools, Data, Window, Help are
there
 
D

Dave Peterson

Rightclick on an empty spot on one of the other toolbars
select customize
Toolbars tab|select worksheet menu bar

If that doesn't work:
Open excel
hit alt-f11 (to get to the VBE where macros live)
hit ctrl-g (to see the immediate window)
type this and hit enter:
application.commandbars("worksheet menu bar").enabled = true
 
G

Guest

thanks dave, first option worked


Dave Peterson said:
Rightclick on an empty spot on one of the other toolbars
select customize
Toolbars tab|select worksheet menu bar

If that doesn't work:
Open excel
hit alt-f11 (to get to the VBE where macros live)
hit ctrl-g (to see the immediate window)
type this and hit enter:
application.commandbars("worksheet menu bar").enabled = true
Click to expand...
 

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

Similar Threads

Menu Bar disappear 1
excel toolbars File Format Insert Tools aren't working 1
Problem with sheet tabs 2
missing the File, Edit, View tool bar 1
Missing Excel option 8
Excel: Expose whole window or at least top resize handles. 1
lost insert hyperlink option on right click 2
Top menu 2

Top