Recent content by jjjjjjohn

Hi Markus, Your and Gavin's help have been fantastic and I really do appreciate it. We didn't get all of what I was hoping to accomplish but we did get 95% of it and that is a lot more than I would have gotten on my own. I think there must be a way to automatically build the drop-down menus...

Hi Laurie, IMHO you should take a class at the local community college or whatever. You say you don't want to become a programmer but want to understand what an object is or what it means to declare a variable. These may seem like simple things buy I think they are actually VERY difficult...

Hi Gavin and Markus, I was thinking the same thing so I also tried adding it to a standard menu. Since I wasn't sure what the name of the standard menu was I just used the index number instead of the control name. Application.CommandBars("Custom Toolbar").Controls("Budget Tools").Move Bar:= _...

Hi Gavin and Markus, Great! That works. The only thing I would want to change would be to have the custom toolbar control added to a specific control (either custom or standard) on the "Worksheet Menu Bar" Command Bar. I tried the following: Application.CommandBars("Custom...

Hi Gavin and Markus, Now I got it. I made the custom toolbar, attached it, deleted it and got it to show up again by opening the original workbook. But how do I apply this concept to a sub-menu like this (http://spreadsheetpage.com/graphics/tips/menu2.gif)? There doesn't seem to be an "append"...

Hi Gavin and Markus, You guys are great and I really appreciate it. I almost understand what you are saying but part of it still escapes me. The parts about the network drive and changing the startup path are clear to me but... Would I make the sub-menu manually or with code? I first tried...

Hi Markus and Gavin, Thanks so much for the information but I'm affraid you've lost me a bit. Gavin's reference to "custom toolbars" and Markus's reference to "user-defined commandbar" makes me wonder if we are talking about different things. For me a "custom menu" is something like this...

Thanks for the info Gavin, I found the .xlb file on my computer but I'm disappointed that I can't export/import only the settings I want. Do you happen to know exactly which settings are stored in the .xlb? I'm distributing this add-in to only about 10 users so I was thinking I could try...

Hi there, I have developed an Add-In which I would like to distribute throughout the company. On my computer I have developed a custom menu which calls the various macros in the add-in. The menu items also have icons. I have figured out how to distribute the add-in itself but I can't figure...