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