Normally, ActionControl is invoked when a button on a toolbar or a menu is
pressed, that is included in its OnAction macro. That way, you have implicit
access to the object pressed.

To make your menu only visible to that workbook would need to set the
visibility property to True/False in the workbook activate/deactivate
events.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"majikman " wrote in message
...
Bob,

i tried both of the below lines and neither works. it gives me a
compiler error saying that data member wasn't found

Application.CommandBars("Worksheet Menu Bar").ActionControl.State =
msoButtonUp

Application.CommandBars("Worksheet Menu Bar").State = msoButtonUp

however,
Application.CommandBars.ActionControl.State = msoButtonUp

does work. however, that line will only apply the state of the .State
member to the worksheet or chart that it is caled from. do you see what
i might be doing wrong? thanks

btw, what code do i add to make my menubar visible only in the workbook
that the vba code is existent in? i don't want the menubar to show up
when another workbook is open at the same time, which it currently is
doing.


---
Message posted from http://www.ExcelForum.com/