Excel 2003 - Recovery of Lost Tool Bars

[Steve SME]

Hi,

Can soemone please help.

I recently received an excel 2007 file by email from a safe source (I
believe) the file ext may have been .xlsx without realising I opened and had
(?) accept or extract on the pop up message.

I've since lost my built in menus - now restored with assistance using
visual basics editor running a macro.

However the standard and formatting tool bars have been lost and I cannot
recover. Using Tools, customised, options and reset doesn't work.

Any ideas greatly appreciated.

Thank you Steve

 

[Bob Phillips]

Go to the VBIDE (Alt-F11)

Make sure the immediate window is open (Ctrl-G)

Type

Application.Commandbars("Standard").Enabled = True

and Enter, and then

Application.Commandbars("Formatting").Enabled = True

and Enter

 

[Steve SME]

Bob,

Instructions worked. Thank you for your help - very much appreciated.

Regards Steve