Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lost highlighting sum tool in Excel | Excel Discussion (Misc queries) | |||
password recovery tool | Excel Programming | |||
Excel Tool Bars | New Users to Excel | |||
Lost all my menu bars and tool bars | Excel Discussion (Misc queries) | |||
I have lost my menu bars in Excel? | Excel Discussion (Misc queries) |