ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Editor Menu (https://www.excelbanter.com/excel-programming/441882-vba-editor-menu.html)

Mike H.

VBA Editor Menu
 
The VBA editor menubar is gone. I don't know what I did or how I did it but
how do I get it back?

Jacob Skaria

VBA Editor Menu
 
Did you try ViewToolbarsEdit

--
Jacob (MVP - Excel)


"Mike H." wrote:

The VBA editor menubar is gone. I don't know what I did or how I did it but
how do I get it back?


Mike H

VBA Editor Menu
 
Mike,

I never saw this in E2003 but since moving to E2007 I see it occasionally
and have never found a fix other than to close and then re-open the VB editor
which restores the File|Edit etc.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mike H." wrote:

The VBA editor menubar is gone. I don't know what I did or how I did it but
how do I get it back?


Mike H.

VBA Editor Menu
 
Closing and reopening worked. That is my #1 rule for fixing anything but I
didn't try it--I panicked! It worked.

"Mike H" wrote:

Mike,

I never saw this in E2003 but since moving to E2007 I see it occasionally
and have never found a fix other than to close and then re-open the VB editor
which restores the File|Edit etc.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mike H." wrote:

The VBA editor menubar is gone. I don't know what I did or how I did it but
how do I get it back?


Jacob Skaria

VBA Editor Menu
 
The below registry entry which hold the settings will get reset/recreated
when you restore your settings/reinitiate the application

HKEY_CURRENT_USER\Software\Microsoft\VBA\Office


"Mike H" wrote:

Mike,

I never saw this in E2003 but since moving to E2007 I see it occasionally
and have never found a fix other than to close and then re-open the VB editor
which restores the File|Edit etc.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mike H." wrote:

The VBA editor menubar is gone. I don't know what I did or how I did it but
how do I get it back?



All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com