Create Menu Options In The VBE

Apr 18, 2009

I have a workbook (VBE.xls) that creates menu options in the VBE when it opens.
Several of them modify the code in the active codepane.

When the codepane is in VBE.xls, everything gets reset and my macros don't run anymore. I have to re-run the macro (menu_setup()) that creates the menu options.
I don't think there is anything I can do about it resetting when I modify the project that created the menus.

Is there some way to have each macro re-run menu_setup() AFTER it has ended (after the reset has cleared everything)?

I've tried having each macro open the immediate window and paste in "menu_setup" then tried to use "sendkeys" command to execute it, but I can't seem to get it work.

View 5 Replies


ADVERTISEMENT

Menu Structure: Opens A Menu Next To It With Different Options

Jul 15, 2006

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

Submit Options From Dropdown Menu And Get Data From Website

May 26, 2014

I am trying to get data from this site in excel. I need to select options from drop down menu (like bank name, balance sheet and date).

View 5 Replies View Related

Create A Default Template That Will Apply All The Same Formatting, Print Options

Nov 5, 2004

Is there any way to create a default template that will apply all the same formatting, print options, etc to every new workbook that I create. I guess what I am asking is a way to change the excel defaults for text type, border size/color, etc.

View 4 Replies View Related

Excel 2007 :: How To Create Dropdown List But Options Reducing After Every Selection

Aug 17, 2011

Is it possible to do a drop down list that allow user to select pre-defined selections but everytime when a selection is chosen, the list reduced?

Example,

I have can choose Apple, Orange, Durian and Mango.

The drop down can only select these 4 fruits.

So there are 4 cells in Column A1, A2, A3, A4.

A1 selects Mango and then A2 will only have 3 options to choose. So until the last cell, he can only choose the last fruit left.

A1, A2, A3, A4 are not selecting in descending order thus it could be A3 selecting first, then A2 and then A4.

I'm using excel 2007

View 13 Replies View Related

How To Create Dropdown Menu

Feb 12, 2013

i looking for a drop down menu ..! like year , month so that no change that area

View 2 Replies View Related

Create Cell Dropdown Menu?

Jan 14, 2013

Need to create a drop down menu for a cell that allows selection of 1 of the 5 to 10 alternatives by clicking on an item in the drop down. Have seen this done by attaching a down arrow button to the cell.

What is this feature called, and how do I go about setting this up?

View 1 Replies View Related

Create RMB Popup Menu In Userform?

Jan 25, 2010

I would like to create a simple right mouse button popup menu for the text box on a userform. I just want Copy and Paste and the functionality that goes with them if possible.

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

Create Floating Toolbar (not Menu)

Jan 13, 2007

Need to code to create a custom floating menu which appears on opening the workbook. It works brilliantly, but I'd like to adapt it so that I can create a floating toolbar, which is fully expanded upon opening, where the button faces are plain text which I designate. Let's suppose the macros I want the buttons to trigger are called MacroA and MacroB, and that the text on the buttons should read "Do A" and "Do B".

Sub Create_Menu()
Dim MyBar As CommandBar
Dim MyPopup As CommandBarPopup
Dim MyButton As CommandBarButton
Delete_Menu 'make sure commandbar isn't already running
Set MyBar = CommandBars.Add( Name:="My Menu", _
Position:=msoBarFloating, temporary:=True)
With MyBar
.Top = 175
.Left = 850
Set MyPopup = .Controls.Add(Type:=msoControlPopup)
With MyPopup
.Caption = "My Tools" 'change to suit....................

View 6 Replies View Related

Create Dropdown Menu That Results In Values?

Aug 12, 2013

I need cell d4 to display the number in column b next to the applicable insurance company when the insurance company is selected from the drop down menu in cell c4. How do I do this?

View 4 Replies View Related

Create Shortcut On Windows Start Menu

Jan 29, 2009

Split off from Create Desktop Shortcut With VBA Macro

Try WSH.SpecialFolders("StartMenu")

List of Special Folders at link -
http://msdn.microsoft.com/en-us/libr...xe(VS.85).aspx

View 2 Replies View Related

Create Sheet/Worksheet Navigation Menu

Sep 28, 2006

Im building a Menu list for my customers. I want to do it in XL sheet format. Can i know how to create tabs (like hand should apprear,when cursor come to the tab and should be like button, where we can name it) in the main sheet?. I have lot of innovative Ideas to come with beautiful menu file i need your assistance further to build my menu list.

View 9 Replies View Related

Create Button In Excel Menu For Macro

Jun 10, 2008

I am trying to make this code works by Toggle botten in Mymenu.

when i press the toggle bottun the copy takes place, then move the curser to distenation and press the Toggle again to past only the comment.

How to make the Toggle bottun inside Mymenu (A menu in the Worsheet Menu Bar).

Sub Macro1()
' Selection.Copy
Selection.PasteSpecial Paste:=xlPasteComments, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End Sub

View 4 Replies View Related

How To Create Excel Add-in With Custom Dropdown Menu For Other Users

Feb 12, 2013

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

View 6 Replies View Related

Create Functional Dropdown Menu To Update Expiry Dates?

Jan 13, 2013

I am creating a very simple spreadsheet to manage my gym memberships. It basically has membership number, first name, last name, membership type (drop down box) start date and expiry date. I have put in conditional formatting so that the expiry date goes red when expired but i want to try and automate the inputting of the dates so for example.

If i select '1 week membership) from the drop down box in the membership type box it will firstly change the start date to the current date (i think this is using the NOW() function) and secodnly changes the expriry date to todays date plus 6 days. Ofcourse i want the expiry date to increase depending on the selection so if i select 1 month membership it would be now date plus 28 days.

I am stuck as to how i can do this and from internet tutorials have been told it requires macro as it cant be done any other way?

View 14 Replies View Related

Using Command Button And VBA To Create Summary Reports Relative To Pull Down Menu?

Sep 16, 2012

See attached file - I would like to use the "Create Parts issue Report" Button to create worksheet titled "Parts Issue Report" based on the pulldown menu in cell B1 tab "Vehicle data" so each pulll down will generate a different "Parts Issue Report" when clicking the "Create Parts Issue Report" button. I think it needs to be a looping VBA to go thru the "Vehicle Data" rows and columns looking for the keywords "late" or past" as I only want a report created on that criteria. The output criteria I have label in the tab "Parts Issue Report" I can explain further if needed.

View 1 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

Menu Bar/Navigation :: Tool That Creates A Menu Bar Or Code?

Oct 20, 2009

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

View 11 Replies View Related

Drop Down Menu: Add Another Selection To The Menu List

Oct 18, 2008

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

Menu Pathing (execute The Macro From Menu)

Jul 2, 2009

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

View 4 Replies View Related

Window Menu In The Main Menu Bar Deleted

Mar 27, 2009

I 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

View 9 Replies View Related

Chart Menu Bar Won't Change To Data Menu Bar

Apr 26, 2007

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

View 6 Replies View Related

Counting Menu Items In Menu Bar

May 20, 2006

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

View 3 Replies View Related

Sub-Menu Not Showing On Toolbar Menu

Jul 8, 2007

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

Addin Under A Menu Of Menu Bar

Jun 21, 2007

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

IF Function With 3 Options

Jun 11, 2014

I am trying to write a formula with the following:

-if I9=0, then write 0
-if I9=501, then write 1
-if I9=502, then write 2

What would be the best way to write this formula? I am sure this should be pretty basic, but everything I try comes up with an error.

View 10 Replies View Related

Dropdown Box Options

Jul 7, 2007

i am currently designing a userform which has a drop-down box for user to choose from the options given. However, i would like to have in the box fields such as "--Subjects", "English", "Maths", "Science". In this way, the user will be shown a list of options of the different subjects for them to choose from as well as to clearly identify to them that these are the subjects available therefore the heading "--Subjects". I would also have to make sure that the user can only select "English", "Maths", "Science" and NOT "--Subjects".

View 11 Replies View Related

VBA Security Options

Oct 12, 2009

We have developed an Excel workbook with hundreds of lines of VBA code written for a specific application, and we would like to protect it.

Could someone give me an idea of what security options we have over and above the below (if any)?

We have protected all sheets and the workbook itself with passwords. The VBA itself is protected with a passoword.

My understanding is that VBA can be hacked into quite easily.....is there any way of adding another layer of security/protection without having to move to another platform altogether?

View 6 Replies View Related

Rounding With Three Options

Nov 26, 2008

numbers in one column need to be rounded to the nearest half decimal, with next conditions(ill took number 704,00 for example):
- if last two decimals are < 0,25 then my number has to be 704.00
- if last two decimals are >0,25<0,75 then my number has to be 704.50
- and finally if last two decimals are >0,75 then my number has to be 705.00

I tried with IF, CEILING, INT and ROUND functions but i didn't made it work with three options, that i need. I only made it work if i use only two options.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved