Menu Bar Preferences..

Jul 30, 2009

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

View 2 Replies


ADVERTISEMENT

Print Preferences

Aug 7, 2007

When I print, can I have the [VBA?] preferences not to print D16:E16?

View 9 Replies View Related

Universal Viewing Preferences....

Sep 24, 2009

Is there a way so that on his computer he can tell Excel that each sheet to be viewed should have a standard/automatic view set to 100% or another percentage?

View 3 Replies View Related

Time And Graph Preferences

Jun 18, 2008

I'm having a couple of Excel problems.

1. I have a SQL query that returns a time span. Is there any way Excel can convert, for example, 51.9451388888889 into dd.hh:mi format that still allows me to manipulate the data as time so that I can add times together and compare times. So I would like the number above to be formatted to look like this '51.22:41' and still be able to work with it as if it was just a regular time.

2. I want to make a graph from this data I have (the data in the question above). The data has this output format:
A ----B-----C
Date-time ( dd.mm.yyyy hh24:mi)----- Time span -------- Reason

I would like to make a graph that displays for each month the 5 highest Timespans on the y-axis and their reasons on the x-axis.

View 9 Replies View Related

How To Save The Layout And Other Preferences / Settings

Feb 25, 2009

Is there way we can save the layout and other preferences / settings (and there are a huge no of those in excel) to a file or can we copy out the file where excel saves this data ? Probably a User Interface folder or something ? This is so that when i do a fresh reinstall of MS OFFICE i dont want to spend so much time resetting the customizations ive created over time.

View 5 Replies View Related

Preferences Keep Defaulting To Manual Calculation

Dec 22, 2009

I am on a Mac running OS 10.4.11. Whenever I launch Excel 2008, I have to go to Preferences and set Calculation to automatic.

Then Excel calculates automatically until the next time I launch the program. Then I find it has defaulted back to manual.

View 3 Replies View Related

Retrieve External Data With The Preferences

Sep 30, 2008

basically all it does is retrieves external data with the preferences that I set... what I want to do is change the code so that instead taking the same URL address it refers back to a specific cell in a workbook for the address.

View 3 Replies View Related

Auto Copying Entered Preferences From A Master Sheet To Multiple Worksheets

Jun 26, 2009

I have a master page with A1 containing the names of staff members and then 5 columns indicating preference1 .... preference5. Each preference column will have one 4 digit site code i.e. 8156 entered. I will have 64 worksheets matching all potential 4 digit site codes that could be entered in the preferences columns.

SAMPLE - one staff member entering 5 site codes (A1 to A6)

Billy Bloggs - 8124 - 8456 - 8456 - 8123 - 8882

What I am looking for is a way to autocopy the persons name to the appropriate worksheet and into the correct preference column as I enter the 4 digit code against the staff members name on the master sheet.

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

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

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

Menu Always Available

Mar 23, 2007

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

View 9 Replies View Related

Menu Available Depending On Yes Or No?

Dec 5, 2013

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

View 12 Replies View Related

Edit Menu

Jan 24, 2007

I 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

View 14 Replies View Related

Tool Bar Menu

Feb 18, 2008

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

View 10 Replies View Related

Creating Sub Menu's

Oct 18, 2008

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

Modify The Menu Bar

Mar 19, 2009

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

Set Up A Menu Bar And I Want To Run Two Macros

Dec 24, 2009

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

More Drop Down Menu

Jan 7, 2009

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

View 3 Replies View Related

Print Menu

Mar 10, 2007

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

View 7 Replies View Related

Delete Sub Menu

May 16, 2007

i 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

View 3 Replies View Related

Add-in Menu Creation

Jul 19, 2007

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

View 8 Replies View Related







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