How To Open A Workbook When Select Custom Tab In Ribbon Menu

Oct 5, 2012

I 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


Default Ribbon To Open Custom Tab Not Home Tab

Jul 15, 2014

I created a custom tab withthe UI editor into my personal sheet which is set as startup and I want to have this tab automaticly shown when it is opened.

So when the workbook is opened I would like the show the tab Andre rather than the home tab.

View 4 Replies View Related

Custom Ribbon Menus Don't Work Until Save, Close & Re-Open

Feb 15, 2010

Created a new tab and menu buttons on the Ribbon in Excel in 3 separate .xltm files. Everything worked great through all of the development and testing, but when we went live we got reports of a bug. Here is what is happening...

User opens the template file and immediately saves it as a .xlsm file with a new name in a new location. The user then does various amounts of work in the file. When the user needs to use one of the tools on the custom tab, it is as if the buttons are inactive or not associated with any actions. The tab and buttons are all visible, the animation of the button being pressed works when any of the buttons are clicked, but nothing happens. The user can close and reopen the file and the ribbon buttons will work correctly, but not until they close and reopen.

Upon digging into the problem, we found that if the user clicks on the custom tab before they save the file, all of the buttons will work correctly after the save. But if the tab is not activated before the save, they dont work until a close and reopen.

The XML code is good because if I place it in a add on file (.xlam) and trigger it from the main file, there is no problem. But this is not a good solution since the add on file needs to be located in the same file that the main file is run from which can be any number of places.

View 3 Replies View Related

Add Custom Menu Upon Opening Workbook

May 12, 2006

I'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 Related

Showing Custom Menu In One Workbook

Nov 30, 2007

I 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 Related

Custom Menu For 1 Workbook Not Deleting On Deactivate

Jan 20, 2008

The 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


Private Sub Workbook_Deactivate() 'Changed Deactivate to Close
Run "DeleteMenu"
End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)
Run "DeleteMenu"
End Sub

View 9 Replies View Related

Adding Item To Top Menu Ribbon?

Feb 25, 2012

I have some old code I use to use that still works but instead of adding to the top menu, the new command button is added to the add-ins menu list and then burried with other items.

Public Sub test()
Set myMenuBar = CommandBars.ActiveMenuBar
Set newMenu = myMenuBar.Controls.Add(Type:=msoControlPopup, temporary:=True)
newMenu.Caption = "Blotter"


View 4 Replies View Related

Replace Standard Shortcut Menu With Custom Menu?

Jun 24, 2014

I 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] ......

View 4 Replies View Related

How To Add To Custom Ribbon Tab That Is Built As Add-in

Nov 8, 2012

I am looking for the settings if possible that will add to a custom tab in the ribbon.

What I have is an add-in that creates a custom tab in the excel ribbon. I save it as an add-in and activate it in excel options so it is available for all workbooks.

Now I have a callback in there that runs a macro that opens a workbook, this workbook also has custom UI that I want additional callbacks added to the same custom tab created in the add-in.

Is this possible?

View 2 Replies View Related

Copy Data From Workbook / Open Existing Workbook - Select Range And Paste

Mar 26, 2012

Copy data from workbook, open existing workbook, select range and paste. But my copied data is lost.

Sub Select_Copy_Paste()

[Code] .........

' Here i need to do something to paste data into r.address?

View 4 Replies View Related

Custom Ribbon Button To Load Add-In?

Aug 8, 2013

I have a pretty developed add-in I've created for use at work. It has 3 full custom ribbon tabs worth of buttons and boxes and other features that run all of the macros in the project. Everyone loves it. The only problem is, its only used when we work with customer statement excel files. When using Excel for other tasks it is annoying to have 3 extra, essentially useless tabs taking up space on the ribbon.

Is it possible to create a button and stick it on, say the Data tab, that will "Start" the add-in and make the 3 custom tabs visible? Ideally there would also be a button to "Close" the add-in or hide the extra tabs until they're needed as well, but how to customize for my specific needs.

View 1 Replies View Related

Excel 2010 :: How To Assign RELATIVE Macros To Custom Ribbon

Aug 19, 2014

I currently have an excel workbook (2010) in which I created a custom ribbon and assigned several different macros to the buttons.

Long story short, I will be saving several variations of this workbook every so often when I get new data.

The problem is that if I change the name of the file (Save as or Rename), the custom ribbon buttons no longer work. When I assigned the macros to the ribbon buttons, the macros were absolutely assigned.

Is it possible to assign relative macros to custom ribbons?

From research I have done, it appears that custom ribbons cannot be created using VBA. Is this still true?

View 6 Replies View Related

Excel 2007 :: Custom Controls Not Showing In Add-ins Ribbon Tab And XML Error

Jul 18, 2013

We are using Windows7 with Excel 2007. We have old code from excel 2003 and earlier that was adding a msoControlPopup with other sub-controls using the code below:

Set HelpMenu = CommandBars(1).FindControl(Id:=30010)
If HelpMenu Is Nothing Then
' Add the menu to the end


I tried going to Excel Options>Customize>Reset to reset any customizations to the quick access toolbar as this was recommended by something else I found online. This did not fix the problem.

I can find the control in the Immediate window but it just isn't showing in the add-ins tab. if I can find and repair that XML file perhaps?

View 9 Replies View Related

Excel 2010 :: Can't Save Custom Table Style Format So That It Is Available Next Time When Open Workbook

Jun 10, 2013

I'm a fan of the Excel 2010 table styles, but can't figure one thing out. When I create a table in excel (Ctrl+T), I like to reformat it with a new defined style. When I save the style, I can use it while I'm in that instance of excel, but when I close and reopen excel, the style is gone. How to save the custom formats to they are always available?

View 3 Replies View Related

VBA Code To Select Specific Sheet Upon Open Of Workbook?

Jan 11, 2013

I am looking for the code that I would use so that when the workbook is opened it would always open with "Main" sheet.

View 4 Replies View Related

VBA Code To Allow User To Select Range In Another Open Workbook?

Jul 26, 2013

I need the code to allow a user to select a column of their choice in an open workbook of their choice so that data can be lookuped up and changed. I am happy to create the code to do the lookup/changing, however the nearest I have found is the use of an inputbox which is limited to the active spreadsheet only. Some people have said the input box could be used over to another spreadsheet but I have not found that to work.

What I will need returned is the workbook name, sheet name and column. That will allow me to point to that and do the task.

This code could be used by 5 people and those 5 people could be running it on 20 different spreadsheets.

I thought this would be easy to find but it has eluded me. When using Excel normally, if you do a simple lookup formula, or create pivot function, excel prompts the user to select the workbook/sheet.

View 4 Replies View Related

Custom Menu Bar

Aug 17, 2009

i 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 ...

View 6 Replies View Related

Custom Menu Disappeared.

Jun 17, 2009

Just 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...

View 5 Replies View Related

Custom Menu In Template Only

Aug 22, 2006

I 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 View Related

Right Click Custom Menu Repeats Itself

Dec 26, 2010

I 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?

View 2 Replies View Related

Create Custom Menu Items For Add-in

Feb 15, 2010

I 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

View 5 Replies View Related

Add List As A Subchoice To A Custom Menu

Jun 2, 2006

I 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.

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

View 9 Replies View Related

Delete Custom Menu Bar / Toolbar

Oct 26, 2006

I 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 Related

Custom Worksheet Menu Bar Item

Apr 5, 2007

I 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 Related

Add Icon To Custom Toolbar Menu

Mar 4, 2008

how 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 Related

Add Custom Menu Item / Toolbar

Apr 12, 2008

Trying 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

View 2 Replies View Related

Excel 2013 :: Custom Menu From Add-in VBA Not Working?

Feb 16, 2014

I 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.

View 2 Replies View Related

Custom Menu Code Missing Or Hidden

Dec 2, 2008

A 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.

View 14 Replies View Related

Assigning A Name To A Custom Button On The Tools Menu

Apr 3, 2007

how 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?

View 4 Replies View Related

Duplicate Custom Menu Buttons When Creating Them

May 29, 2007

I 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: ....

View 9 Replies View Related

Copyrights 2005-15, All rights reserved