Good Morning/Afternoon/Evening
When I first opened a blank workbook and clicked on the Developer Ribbon and then on the Visual Basic icon, the VB interface was displayed but only with the top main menu (File, Edit, View, etc.) and three blank tool bars. See screenshot
This is the first time I've tried to add an image to a thread post. So, I don't know if it worked.
I'll try more descriptive way just in case.
The first line in the open VB Editor is the Main Menu with the words File, Edit, View, Insert, Format, Debug, Run, Tools, Add-Ins, Window, and Help.
The next line is what appears to be a short tool bar with three vertical spacer icons and when I pass the cursor over where icons should be I get FlyOver popups like - Design Mode, separator bar, Run Macro , Break, Reset, separator bar, Toggle Breakpoint, Step Over, Step Out, separator bar, Locals Window, Immediate Window, Watch Window, Quick Watch, Call Stack then the icon for Tool Bar Options.
The next line shows a tool bar that starts with the Excel Icon, then the drop down menu for inserting UserForm, Module, Class Module, and a lot more blank icons with the last one Microsoft Visual Basic for Applications Help and ends with the icon for Add Remove Buttons.
The next line shows a short tool bar labeled Project - VBAProject. I don't recall ever seeing this one before.
I've tried clicking the View menu commands Toolbars option and I get a pop up with Debug, Edit, Standard, UserForm choices arrayed in a column. With a check mark next to Debug and Standard. But, when I move the cursor over either of those check marks the check mark disappears.
When I click on one of the drop down menu options like, Debug - even though the check mark is gone- by clicking on it, it makes that tool bar go away. When I click on the Edit option (which did not have a check mark) that tool bar is displayed - but with no icons.
I've closed and reopened Excel several times. Same behavior. I've rebooted (Windows 7) several times. Same behavior.
Anybody know what the heck is going on?
Thanks,
George Teachman
When I first opened a blank workbook and clicked on the Developer Ribbon and then on the Visual Basic icon, the VB interface was displayed but only with the top main menu (File, Edit, View, etc.) and three blank tool bars. See screenshot
This is the first time I've tried to add an image to a thread post. So, I don't know if it worked.
I'll try more descriptive way just in case.
The first line in the open VB Editor is the Main Menu with the words File, Edit, View, Insert, Format, Debug, Run, Tools, Add-Ins, Window, and Help.
The next line is what appears to be a short tool bar with three vertical spacer icons and when I pass the cursor over where icons should be I get FlyOver popups like - Design Mode, separator bar, Run Macro , Break, Reset, separator bar, Toggle Breakpoint, Step Over, Step Out, separator bar, Locals Window, Immediate Window, Watch Window, Quick Watch, Call Stack then the icon for Tool Bar Options.
The next line shows a tool bar that starts with the Excel Icon, then the drop down menu for inserting UserForm, Module, Class Module, and a lot more blank icons with the last one Microsoft Visual Basic for Applications Help and ends with the icon for Add Remove Buttons.
The next line shows a short tool bar labeled Project - VBAProject. I don't recall ever seeing this one before.
I've tried clicking the View menu commands Toolbars option and I get a pop up with Debug, Edit, Standard, UserForm choices arrayed in a column. With a check mark next to Debug and Standard. But, when I move the cursor over either of those check marks the check mark disappears.
When I click on one of the drop down menu options like, Debug - even though the check mark is gone- by clicking on it, it makes that tool bar go away. When I click on the Edit option (which did not have a check mark) that tool bar is displayed - but with no icons.
I've closed and reopened Excel several times. Same behavior. I've rebooted (Windows 7) several times. Same behavior.
Anybody know what the heck is going on?
Thanks,
George Teachman