Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2008

Tip: Looking for answers? Try searching our database.

Accessing New Menu code

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rnosk - 03 Mar 2008 18:01 GMT
After interactively adding a menu item (tools/customize/commands/new menu) to
the excel toolbar is the code available to edit?  I've created a layered menu
but I can't seem to find the resulting code.
FSt1 - 03 Mar 2008 18:50 GMT
hi
custom menu item and custom icons have macros assigned to them.
the code should be in the vb editor somewhere. Alt+F11.

regards
FSt1

> After interactively adding a menu item (tools/customize/commands/new menu) to
> the excel toolbar is the code available to edit?  I've created a layered menu
> but I can't seem to find the resulting code.
rnosk - 03 Mar 2008 19:13 GMT
That's what I thought but I'm not seeing the resulting code.  I don't know if
its hidden or specifically not made available.  I can certainly write VB to
produce the menu but I would get a jump start if this code was available.

> hi
> custom menu item and custom icons have macros assigned to them.
[quoted text clipped - 6 lines]
> > the excel toolbar is the code available to edit?  I've created a layered menu
> > but I can't seem to find the resulting code.
Dave Peterson - 03 Mar 2008 19:28 GMT
I think it's better to do all the work in code.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm  -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.

> After interactively adding a menu item (tools/customize/commands/new menu) to
> the excel toolbar is the code available to edit?  I've created a layered menu
> but I can't seem to find the resulting code.

Signature

Dave Peterson

rnosk - 03 Mar 2008 21:27 GMT
Thanks Dave.  I suppose I can't cut corners by using the code generated while
I did the interactive version.  Your links were helpful.

> I think it's better to do all the work in code.
>
[quoted text clipped - 21 lines]
> > the excel toolbar is the code available to edit?  I've created a layered menu
> > but I can't seem to find the resulting code.
Dave Peterson - 03 Mar 2008 22:05 GMT
Maybe or maybe not.

Depends on what that code was.

> Thanks Dave.  I suppose I can't cut corners by using the code generated while
> I did the interactive version.  Your links were helpful.
[quoted text clipped - 28 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.