Window Menu In The Main Menu Bar Deleted
Mar 27, 2009I have actually got the Window menu in the Main Menu Bar of excel deleted using below command.
Application.CommandBars("Worksheet Menu Bar").Controls("Window").Delete
ADVERTISEMENT
TOC: Main Menu Column Insertion
Sep 24, 2008I've been using this code to make menus for all my Excel sheets since NateO made it back in 2003.
- The workbook has 370 sheets, 365 of them are one day per month with the tab named ddmmmyy.
- The Main Menu in this file puts the months Jan, Feb, Mar, etc in cells A3:L3.
- In the single cells under each month it put the month day tab name (ddmmmyy) and hyperlinks it to the sheet tab.
I would like to do two new things.
1. Put the name of the month in everyother cell in row 2, so Jan would be in A2, Feb in C2 and Mar in E2, etc.
2. Put the day of the week for each date in the cell to the right of the date. So the column heading would be Jan in A2, 01Jan08 in A3 and Tue in B3.
I thought I could make another macro and just insert the rows after the Main Menu was built and then VBA copy/paste TEXT(cell,"ddd") down the ranges, but thought there might be a better idea out there...
Sub Workbook_TOC()
Dim ws As Worksheet
Dim wsNw As Worksheet
Dim z As Integer
Rightclick Cell Menu Deleted
Apr 24, 2009I was customizing my rightclick cell menu, for cells in certain columns, to add some links to files and then I would delete them when right clicked in some other column.
By mistake I deleted EVERYTHING from my rightclick menu. If found where the problem was so it wouldn't happen again.
So now I am trying to put back those basic commands in the rightclick menu , but I cannot get those 'icons' that shows up on left of each command. how to get that?
Creating Main Menu On Userform Using API Calls
Jun 17, 2011I am trying to create a "mainmenu". On a Userform using API calls.
Created a Userform and named it Form1.
Added a command button to the form and named it Command1.
In THISWORKBOOK code:
Private Sub Workbook_Open()
Form1.Show
End Sub
[Code] .........
I open the file and Form1 is shown with its command button. When I click the command button I get an error:
Run-time error 49:
Bad DLL calling convention.
What is the correct convention?
Disable Window Menu Item
May 23, 2007Is it possible to disable or grey out the windows options in the Tools>options tab?
Run Menu Macro When Window Selected/Deselected
Sep 14, 2006I need code that will let me activate and inactivate a custom menu bar macro when the user leaves/reeturns to the workbook the menu is for. Example: in workbook A (with a cutsom menu bar), the user inputs data, but needs to check or edit workbook B (normal menu bars). I want the menus to go back to normal when the user activates Window WorkbookB. When finished there, and selecting Workbook A, I want the custom menu macro to run again. I already have create/delete code. Would the solution be some type of If Then in the Sheet Code?
View 3 Replies View RelatedReplace 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] ......
Menu Bar/Navigation :: Tool That Creates A Menu Bar Or Code?
Oct 20, 2009I have a workbook with multiple sheets. Is there a tool that creates a menu bar or code that I can add that would support navigation?
My goal is to have something with approximately 4 options (buttons?). They would link to 4 different sheets that serve as indexes within the workbook.
I know I can add a control like a button to a given sheet that would take the user to given sheet when clicked, but can I make the button 'float' above all the sheets, or add to a menu bar, or something? I just don't want to have to add the button to every sheet in the workbook.
I am looking for something simple/easy, and am not looking for anybody to do the work. I just have no idea on how to approach the problem.
Drop Down Menu: Add Another Selection To The Menu List
Oct 18, 2008I have a column with various drop down menu boxes and I need to add another selection to the menu list. My problem is, it's been so long since I did the drop downs, I have forgotten how to do it..
View 3 Replies View RelatedMenu Pathing (execute The Macro From Menu)
Jul 2, 2009I'm adding a menu selection to the right-click menu that you get for cells. I can add and remove the menu option but, when I try to execute the macro tied to the menu, I get "the macro...cannot be found". I can't figure out what appears to be a "pathing problem". I'm sure it's simple but...
Here's the
Menu Structure: Opens A Menu Next To It With Different Options
Jul 15, 2006Now this is something which I dont even know if it can be done, but its something which I would use, a lot. When clicking on a button, like a normal button from the control toolbox, is it possible to open a menu from this? So I click on the button i made called "accounts" and this opens a menu next to it with different options.
View 5 Replies View RelatedChart Menu Bar Won't Change To Data Menu Bar
Apr 26, 2007my worksheet menu bar is displaying the ' Chart' menu no matter what I do. Not only do I have no charts in the workbook, (verified this by: )
For Each ws In Worksheets
ws.Select
MsgBox ActiveSheet.ChartObjects.Count
Next ws
but adding worksheets, selecting various parts of a worksheet, creating a chart and deleting it, and everything else I've tried has no effect.
One interesting thing - the first chart I added (to test if it would 'unstick' itself upon deletion of the new chart) was named 'Chart 2', implying there was a chart1 that existed previously.... although I am fairly certain I never added a chart to this workbook at any point.
Also, the menu bar is working fine in other workbooks, and changes to chart and back to data like normal.
Counting Menu Items In Menu Bar
May 20, 2006Suppose I delete a (unknown) number of items from the Worksheet Menu Bar. This can vary because of the fact that my excel sheet is being used by a different number of people, all with a different Worksheet Menu Bar configuration. Is there a way of counting how many Menu items are still left in the Worksheet Menu Bar?
So, suppose all that is left (after using the program) in the Worksheet Menu Bar are Excel, File, Tools, Help. How can the porgram find out that there are only 4 items in the menu?
Sub-Menu Not Showing On Toolbar Menu
Jul 8, 2007I am taking an EXCEL(online) class and in my current assignment i am to create a 'list' for sorting and querying. However i cannot find the 'list' option, under my DATA option on the toolbar. I have tried all my toolbars and shortcuts but I am unable to find it anywhere.
View 9 Replies View RelatedAddin Under A Menu Of Menu Bar
Jun 21, 2007I have made an excel addin named "INDNUMFOR" and want that this should display under "Data" of main menu bar. thus, a new item (sub menu) should appear naed "IndNumFor" under Data main menu.
View 9 Replies View RelatedMenu Always Available
Mar 23, 2007I used the following to create menu's and run macro.
http://www.ozgrid.com/VBA/custom-menus.htm
The menu is only avaliable in the excel file it was created with.
I want it to be avaliable for ANY file that I open, even if I create a new excel file. I would like to have access to my menu's.
Menu Available Depending On Yes Or No?
Dec 5, 2013Can I make a drop down list only available if another cell contains a Yes.
example :
A1 has a Yes/No drop down list by data validation
If A1 = yes then B1 gives the option of another Yes/no drop down list. If A1=No, or blank, then B1 has no menu option.
Edit Menu
Jan 24, 2007I am using Excel 2000
I have recently opened a file sent to me, and since closing it my Edit menu does not work properly when I open any existing files or start a new file
The problem is with Copy, Cut Paste and Paste Special, when I click on the Edit menu they are all greyed out, also if I right click they are also greyed out
Obviously the file I opened has changed some settings, how do I re-set this
Tool Bar Menu
Feb 18, 2008Within the 'tools' menu option you have 'Macros'. On a standard tool bar you have the option to record a new macro, edit......, however sometime last week I created a custom button and placed icons on my tool bars that allowed me to click them to record new or run custom made macros. After a clicking the 'custom macro' buttons a few times by mistake, I decided to remove the custom buttons in the hope of returning the macro options (within the 'Tools' menu option) back to normal. However this has not been the case. Now I have no option to record a new macro the the 'tools' menu system.....it has disappeard. Please could someone tell me how I can reset the 'Tools' menu system back to normal?
Creating Sub Menu's
Oct 18, 2008I am using the following code to build and remove a menu on the menu bar. how to modify this to create sub menu's instead of a single drop down list
View 2 Replies View RelatedModify The Menu Bar
Mar 19, 2009I have some code that loads and unloads a command under the "DATA" menu bar. Is it possible to add an item to the menu bar and put the commands under the new menu item? For example: Add "XYZ Consulting" as a menu bar item so it would like as follows: File, Edit, Insert, Format, Tools, Data, Window, XYZ Consulting.
View 5 Replies View RelatedMenu Bar Preferences..
Jul 30, 2009I have created an item on the menu bar (called “Personal Macros”) to run a number of macros in a spreadsheet. Under the menu bar I am trying to create two ControlPopups (called “Grouping Preference 01” and “Grouping Preference 02”).
For each ControlPopup, I am trying to add Control Buttons to the right, which will run the macros assigned. For Grouping Preference 01, add Macro 1 and Macro 2 as control buttons. For Grouping Preference 01, add Macro 3 and Macro 4 as control buttons
I have code to create the new menu, add popups, and add control buttons but it is not working as expected. The current code is placing all four macro control buttons under the same ControlPopup. I want the control buttons for macros 1 & 2 under one popup and the control buttons for macros 3 & 4 under another popup.
Custom 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 ...
Set Up A Menu Bar And I Want To Run Two Macros
Dec 24, 2009I have set up a menu bar and I want to run two macros. The code I am using for some reason is only running one of the macros. I can't figure out why the other one will not execute.
View 2 Replies View RelatedMore Drop Down Menu
Jan 7, 2009I can weld together a bare chassis, or a complete turn-key car, or anything in between. With that I am putting prices next to every option, and part n piece that goes on the chassis. This is fine when I choose welded chassis under car type and just add a few options to it.
However if I choose turn-key or even roller, there are items that i need to choose between like rear coilover manufacturer and what not, but I dont need to add that price in considering its already included in the turn-key price of $135,000.00
So my question is, if I choose bare chassis, can I leave everything the same, but if I select turn-key, can I make it so it does not include that price in the bottom total cost of the car?
Print Menu
Mar 10, 2007I would like to create a print menu similar to the one located at http://www.landlordsoftware.com/jpg/printmenu.jpg
build the print menu and set up the appropriate code to do so? I have more sheets than the sample linked.
Delete Sub Menu
May 16, 2007i use Excel2007
a menu appears under the Addin command, it appears from using an Addin, the addin was deleted, how can i delete this menu now ?
i trid this code,
Sub t()
Application. CommandBars("Add-Ins").Controls("Custom Toolbars").Delete
End Sub
Add-in Menu Creation
Jul 19, 2007I am wanting to make a macro into an add-in. An add-in is basically a workbook with macros that is opened when excel is correct? I know how to create an additional menu item under an existing one, but I'm wanting to create my own menu with this add-in item under it. I've used this code to try and create the new menu and placed it in the workbook open:
HelpIndex = CommandBars(1).Controls("Help").Index
Set NewMenu = CommandBars(1).Controls.Add(Type:=msoControlPopup, Before:=HelpIndex, Temporary:=True)
NewMenu.Caption = "&Separate Cashiers"
But ran into an error on the first line of code. I saved the workbook with the add-in macro in it as an .xla and used the addins under tools to have it open each time.
Get X To Appear In Cell From A Drop-down Menu?
Jan 5, 2014Looking to get a "X" to appear in appropriate box "in leave request form tab, cell M14, modified PTO box" that corresponds with correct selection from drop-down menu "in leave calendar tab, cell K6"... if i select "modified PTO from the drop down selection in K6, i would like to see a ""X" appear in "leave request tab, cell M14", then i can apply the formula to the rest of the selections in the drop -down...
View 5 Replies View RelatedAutomatically Run Through Dropdown Menu?
Jul 7, 2014I've got a workbook with multiple worksheets related to several subsidiary companies for each state & territory, resulting in 450+ worksheets in the workbook. I created a summary sheet with a dropdown menu for each state/territory that pulls in the relevant data using "=indirect". For example, selecting CA from the dropdown menu populates the combined revenue, expenses, etc., for all subsidiaries in CA. However, I've got 50 states plus some territories. I'd like the revenue, expenses, etc. for every dropdown option. Ideally, a separate sheet (or whatever) that lists all 50 states and the revenue, expenses, etc., for each one below (or across).
Is there any way to do this automatically so I don't have to select every single option and copy and paste the numbers into a different worksheet?