Custom Menu In Template Only
Aug 22, 2006I have created a nice custom menu but I only want to tie it to only appear when I open a specific template file or any other saved work book from the template file.
View 5 Replies
ADVERTISEMENT
Replace Standard Shortcut Menu With Custom Menu?
Jun 24, 2014I have created a sub to add new controls to the "Cell" shortcut menu. Can I remove the standard "Cell" shortcut menu controls? if so how do you do it?
[Code] ......
Custom Order Template VBA Or Macro
Mar 11, 2008I am trying to write a formula whether it be in VBA or a Macro that will do the following.
In cell A7 and A10 there are validation boxes that drop down with a list of items that can be selected.
We want the user to be able to add multiple items under each month but keep the list to only what is needed. Therefor the function I am trying to get is once cell A7 has a selction or isnot blank or is greater than 0 we want to add a line directly below it with all the same functionality as line 7. Everything else will shift down and maintain the same functionality.
I have a attached a sample workbook... Can this be done
Custom Toolbar/Commandbar For Template
May 17, 2008How can I save a new xlt or xls so that the toolbar settings I am viewing will always reload with excel. I have tried purging all items from my xlstart locations, but unwanted (and unchecked) toolbars keep reappearing when I restart excel.
View 4 Replies View RelatedAdd Custom Sheet Template Macro Code
Mar 21, 2008I am trying to use the worksheets.add method with the Type specifier pointing to a file location containing a worksheet template.
View 9 Replies View RelatedCustom Menu Bar
Aug 17, 2009i had a play with a document that contains a custon menu bar and now the menu bar is always there.
the code that puts up the menu bar is ...
Custom Toolbar Button Setting Certain Template To Open
Sep 20, 2006I created a custom toolbar button which works perfectly.
Because I needed to save each workbook as a specific workbook this is taken care of by the vb code.
I would like when the button is pressed for the original workbook template to be opened.
At this moment if I have a blank workbook or no workbook open and I press the button the programme opens a version of the workbook but not the template version how do I point Excel at the templates.
Custom Menu Disappeared.
Jun 17, 2009Just curious as to what could make a custom menu or custom button disappear from Excel upon opening it. I had created a custom menu with personal.xls macros in it for someone here a while back, and today it was completely missing.. although the Personal.xls folder still existed with the macros.
I am quite sure that they did not manually remove the menu by right-clicking and selecting Customize and dragging back the menu items...
Right Click Custom Menu Repeats Itself
Dec 26, 2010I made custom menu with these instructions: [URL]....
Problem is that when I right click my makro keeps copying itself. Ten times right click=ten my macro in the right click menu. It means that
Private Sub Workbook_Deactivate() doesn't work as it should be?
Create Custom Menu Items For Add-in
Feb 15, 2010I have created an Addin from one I found on this site which creates a menu on the CommandBar. On this menu I can add my Macros. The Menu is initially supposed to perform a delete function then an add, just in case the menu already exists on the CommandBar. It is also supposed to Uninstall the menu when you de-select the Addin. At the moment it doesn't seem to be doing either, as I have now got 5 CommandBar menu's all the same and I can't delete them?
This also creates a problem of when I add another macro, the menu on the CommandBar doesn't update with the addition?
I have attached the .xla file for you to look at and see where I'm going wrong.
VBA Macros & Creating An Add-in For Them
Add Custom Menu Upon Opening Workbook
May 12, 2006I'm trying to load a custom menu in a workbook to avoid having users to load an add in to use the spreadsheet. I'm trying to add this to the "this workbook" tab but I've never done this.
View 3 Replies View RelatedAdd List As A Subchoice To A Custom Menu
Jun 2, 2006I have create a custom menu and want to add a choice and a subchoice that will guide the user to insert a number in an inputbox or under a list. Then the user's selected number it will be used as parameter for a vba code.
Eg.:
The choice is: How many rows will be marked
The subchoice : 10 (default value)
What i want is the following:
If the user choose the above subchoice then it has to be appeared an inputbox or something like that in which he has to insert a number, eg. 45. After that the choice must shows
The choice: How many rows will be marked
The subchoice: 45
This parameter must be active all the time that the user uses the workbook. At the end, if the user saves the workbook, the next time it will be opened, the subchoice must have the value 45.
Look at the attachment image to see exactly what i want
Here's the code. Just copy it under a module
Option Explicit
Dim cbMenu As CommandBarControl
Dim cbSubMenu As CommandBarControl
Public MenuSeries
Delete Custom Menu Bar / Toolbar
Oct 26, 2006I was making a custom Menu Bar in excel. In order to troubleshoot I executed the code a no. of times, resulting in multiple but same menu bars in excel application. Now the problem is that even if I quit excel, the menu bars dont seem to go..How do I get rid of them.
View 2 Replies View RelatedCustom Worksheet Menu Bar Item
Apr 5, 2007I am working on a workbook that has a custom worksheet menu bar item created every time the file opens. If I try to edit the path of these macros and save the file, when i reopen the file, it is back to the original paths. I can't find any VB code, hidden worksheets, hidden cells,etc to find the source of this item being created. I have even deleted all VB modules and worksheets except a blank sheet and it still creates the item. Somewhere this menu bar item is being created and I have no idea where. It acts the same on 4 different machines and acts the same on Excel 97, 2000, 2003 and 2007.
View 4 Replies View RelatedShowing Custom Menu In One Workbook
Nov 30, 2007I have downloaded a custom menu workbook attached. I am wanting to only show the custom menu in one workbook as it appears in all workbooks open at the time.
View 3 Replies View RelatedAdd Icon To Custom Toolbar Menu
Mar 4, 2008how to manage a custom faceid. Though, I am not too sure as to how to assign an actual icon to a custom toolbar. I can try the pasteface method; though as the source file is a .png; the picture might be too small.
View 2 Replies View RelatedAdd Custom Menu Item / Toolbar
Apr 12, 2008Trying to write a VBA code to add a new menu item with submenus on the Standard toolbar when Workbook_Open and then deleting it (_Before close). Just having trouble with the creating of the menu item. Here is what I have so far:
Sub Workbook_Open()
...
Dim menuitem As CommandBarPopup
Set Menu = Application.CommandBars("Menu Item").Controls.Add (Type:=msoControlPopup, Before:=13)
...
End Sub
Custom File Name At Startup Using Macro Enabled Template Format (XLTM)
Jul 17, 2012So I am trying to make a file that when opened will act as a template does and change the file name on start-up.
Typically, the template changes the file name by appending one number (e.g. "Book Template REV 1.1.xltm' upon opening would change the file name to 'Book Template REV 1.11.xlsx'). What I want to do, however, is to custom the name change so I could use the file 'Book Template REV 1.1.xltm' while having it change the file name upon opening to 'Custom Name 567.xlsx', without a user being notified of the change (since typically when a template opens the file, the user has no notification that the file name has changed ever so slightly).
Excel 2013 :: Custom Menu From Add-in VBA Not Working?
Feb 16, 2014I created an add-in with custom VBA and forms, which also stores user preferences in worksheets in the addin. When the add-in loads, it creates a custom menu on the Add-Ins ribbon that allows the user to run the main macro, or to assign a shortcut key of their choosing. It also allows them to enter registration information.
In Excel 2013, the code is all accessible since the add-in still loads, but it doesn't add the custom menu allowing users to interact with the macros. I'm told this is due to the switch to SDI.
It seems that adding Workbook_Open code to a normal file allows the custom menu to be created, but adding the same code to an add-in file does not work.
Custom Menu Code Missing Or Hidden
Dec 2, 2008A spreadsheet that needs a new menu item in a custom menu does not show the custom menu code. Tools-->Customize-->Commands-->Rearrange Commands shows the menu and allows me to add a new menu item and macro.
After saving and exiting excel and going back into the spreadsheet, the new menu item is gone. How can I find the code to do this to keep the menu item? In the VBE, I looked in the object browser(F2) in all of the libraries and could not find the code. In the workbook_open and workbook_activate I can disable it with CommandBars("Worksheet Menu Bar").Controls("menu").Delete and it disappears.
Assigning A Name To A Custom Button On The Tools Menu
Apr 3, 2007how to change the name of a Command Button that I have called "Command Button" on the Tools menu.
Also if I have this button created in my Personal workbook and I send the file to another user what should I do? Will that user be able to see this button ok?
Duplicate Custom Menu Buttons When Creating Them
May 29, 2007I have a workbook that creates three temporary menu buttons when I open it. These work fine until I try and open more then 1 workbook at a time. This creates duplicate menu buttons (3 times the number of workbooks that I open).
I call up the procedure when each workbook is opened using this code in the "ThisWorkbook" code area: ....
Prevent Custom Menu Appearing In All Workbooks
Sep 8, 2007I added a menu command button to a toolbar in a specific workbook. The macro is housed only in that workbook and the macro needs to run on every worksheet in the workbook. However, the button also appears on EVERY Excel workbook that I open when it should not. How can I create a menu command that only appears in the workbook that contains the macro?
View 2 Replies View RelatedCustom Menu For 1 Workbook Not Deleting On Deactivate
Jan 20, 2008The following code for a custom menu is used in a workbook which has two sheets with
embedded charts, two chart sheets and several sheets for calculations
and information
In This Workbook
Private Sub Workbook_Activate() 'Changed Activate to Open
Run "AddMenus"
End Sub
and
Private Sub Workbook_Deactivate() 'Changed Deactivate to Close
Run "DeleteMenu"
End Sub
and
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Run "DeleteMenu"
End Sub
Add Custom Menu At Specific Location On Toolbar
Jun 28, 2008I would like to use the attached "menu maker" file I found on Ron De Bruin's site using a Sheet to build the menu, yet be able to place it before the Help menu as suggested by this site [url] by finding the position of Help.
I have amended the code yet receive a "Compile error: Variable not defined" error.
Dropdown Menu With List And Custom Data Validation?
May 2, 2014I have a Drop-Down Menu that looks like:
BOS
PIT
COL
NYR
using List with source =Lists!$B$2:$B$9, which is just the validation list
My Table:
Team Player
BOS Bergeron
BOS Krejci
NYR Nash
... ...
My goal is to limit the end user from choosing BOS more than two times from the drop down menu
Limiting Custom Menu Selection Based On Sheet Name
Jun 13, 2008i am considering the use of custom menus in an Excel application. is it possible to limit the selection of menu items for each worksheet? for example, sheet 1 all menu items are available, sheet 2 all but 2 menu items are available, sheet 3 all but 5 items are available.
View 10 Replies View RelatedHow To Open A Workbook When Select Custom Tab In Ribbon Menu
Oct 5, 2012I am working on building a custom menu and I am looking for the code that would open a specific workbook execute a macro when I select the tab, can this be done????
View 1 Replies View RelatedHow To Create Excel Add-in With Custom Dropdown Menu For Other Users
Feb 12, 2013I've written a ton of VB macros that do various things to a raw data sheet. I want now to create a custom menu (in the the menu ribbon bar at the top of the screen). I'd like this menu to be used to activate the various macros for whoever has my add-in.
I've found several examples on how to create an add-in, and creating custom menus, however they all for when someone opens a workbook with the code, and then they remove the custom menu when the workbook is closed. I would like my custom menu to stay on the users ribbon bar no matter what workbook they have open. The only time the custom menu should not appear is if the user removes the add-in.
Sample Code To Add/delete Custom Menu Items
Feb 22, 2007Option Explicit
Dim cMenu1 As CommandBarControl
Dim cbMainMenuBar As CommandBar
Dim iHelpMenu As Integer
Dim cbcCustomMenu As CommandBarControl
'(2)
Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar")
'(4)
Set cbcCustomMenu = cbMainMenuBar.Controls.Add(Type:=msoControlPopup)
'(5) Give the control a caption................
I have created several spreadsheet with customized menus. In step 5 when I type
a period the options for selecting Caption does not appear. In step 6 the 'Control' word didn't appear in list. Sometimes the options in step 6 do appear BUT not the option for Controls. I have created spreadsheets with menus that work but the only way I could do it was to cut and paste from the website and then modify it.
