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

[Guest]

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

 

[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

 

[Guest]

Many Thanks Ron, you have saved my life!!..lol

Mick

 

[Dave Peterson]

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
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