URGENT HELP REQUIRED - EXCEL LOADS WITHOUT ANY COMMAND BARS AN
 

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

URGENT HELP REQUIRED - EXCEL LOADS WITHOUT ANY COMMAND BARS AN
 

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Debra Dalgleish has some getstarted instructions for userforms at:
http://contextures.com/xlUserForm01.html

francisA wrote:

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






--

Dave Peterson