Excel Doesn't Display Tools/Options

[emptyi]

I can't get the Options to display from Tools/Options. Any ideas?

Thanks,
Emptyi

 

[xlbo]

Do you have a workbook open ?? Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[emptyi]

xlbo: I have a spreadsheet open and I've opened a blank. Still no tools/options display.

 

[KenWright]

Any of the following VBA commands should bring up an options dialog. the one at the end should bring the overall options dialog box you would expect to see.

Application.Dialogs(xlDialogOptionsCalculation).Show
Application.Dialogs(xlDialogOptionsGeneral).Show
Application.Dialogs(xlDialogOptionsChart).Show
Application.Dialogs(xlDialogOptionsEdit).Show
Application.Dialogs(xlDialogOptionsListsAdd).Show
Application.Dialogs(xlDialogOptionsME).Show
Application.Dialogs(xlDialogOptionsTransition).Show
Application.Dialogs(xlDialogOptionsView).Show
Application.Dialogs(xlDialogConditionalFormatting).Show

Overall command to bring up entire box
Application.CommandBars.FindControl(, 522).Execute


You don't say which version of Excel you are using but if it is any of the following:-

Microsoft Excel for Windows 5.0
Microsoft Excel for Windows 5.0c
Microsoft Excel for the Macintosh 5.0
Microsoft Excel for Windows 95 7.0

then the following link may help:-

http://support.microsoft.com/default.aspx?scid=KB;en-us;q129155

XL: Error or Options Dialog Box Does Not Appear

Regards
Ken............

 

[plantj]

Have you tried right clicking on the menu bar, choose customize then Reset?