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

--
__________________________________
HTH

Bob

"Steve SME" wrote in message
...
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