Excel 2003 - Recovery of Lost Tool Bars
 

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

Excel 2003 - Recovery of Lost Tool Bars
 

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

Excel 2003 - Recovery of Lost Tool Bars
 

Bob,

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

Regards Steve



"Bob Phillips" wrote:

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