Im just a excel user and not a programmer, please help me how to get to
"Sub test()
Dim Cbar As CommandBar
For Each Cbar In Application.CommandBars
Cbar.Enabled = True
'Cbar.Visible = True
Next
End Sub"
A clear instruction would be greatly appreciated. Good luck to you guys

"Ron de Bruin" wrote:

Hi Mick

Alt - F11
select/Run the macro to restore it in the module
of the workbook with the code

If you don't have one try this

Sub test()
Dim Cbar As CommandBar
For Each Cbar In Application.CommandBars
Cbar.Enabled = True
'Cbar.Visible = True
Next
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"MickJJ" wrote in message ...
OK, I have been messing about with VBA and have put into Excel VBA code to
open with NO command BArs or menus showing. Whenever I now open ANY excel
workbook on my PC this is happening, I cannot now select the associated macro
to delete it. IS there a way that I can do this?!??!

HELP!!!!