Replacing the Worksheet Menu Bar

Add-in Express™ Support Service
That's what is more important than anything else

Replacing the Worksheet Menu Bar
 
Scott Johnston




Posts: 31
 Joined: 2006-07-18
Is there any way to replace the Excel worksheet menu bar with a custom one?

I used this code previously in VBA: 


Application.Commandbars.Add Name:="My Worksheet Menu",Menubar:=True,Temporary:=True


I then added items to it.

Can't seem to mimic the same behaviour in Add-in express. I've tried setting the Position to adxMsoBarMenuBar but this doesn't do anything.

Any suggestions?
Posted 29 Aug, 2006 09:39:14 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi Scott.

Now ADX doesn't support creating custom menu bars. We will add this feature to the next ADX build.
As to the adxMsoBarMenuBar constant, it is used for Macintosh only.
Posted 31 Aug, 2006 14:35:59 Top
Scott Johnston




Posts: 31
 Joined: 2006-07-18
Sergey,

Thanks for letting me know. I thought that might be the case. I think I will be able to work around it just now by adding my items to the existing worksheet menu and hiding ones I don't want to see. Then deleting ir hiding my items when I need to...

Scott
Posted 01 Sep, 2006 07:14:05 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi Scott.

Yes, you can use the VBA code in the add-in to replace the menu at the runtime. I tested it yesterday and it worked fine.
Posted 01 Sep, 2006 07:24:23 Top