URGENT HELP REQUIRED - EXCEL LOADS WITHOUT ANY COMMAND BARS AND ME

M

MickJJ

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!!!!
 
R

Ron de Bruin

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
 
F

francisA

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
 
D

Dave Peterson

Top