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

P

pelly

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
 
P

pelly

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...
 
Top