Add Menu Containing Items For User Access?

Mar 30, 2008

What's the easiest/best way to add a menu containing menu items so that a user can easily access custom vba-functionality?

View 2 Replies


ADVERTISEMENT

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

To Access Non-native Menu Commands In VBA

Jan 2, 2009

I have not been able to find any references to anywhere, so here I am....

I'm using Excel 2003 that has a menu bar added by another program that interfaces with it (via DDE, as I understand it). The DLL's from the other program have no documentation and/or ability for me to connect to the particular drop-down menu command I'm using. It is a refresh command that re-imports stock market trade data because DDE drops trade messages.

View 11 Replies View Related

Menu Items In UserForm For GUI

Mar 3, 2008

i'm trying to build a GUI-only application using Excel Userforms, with File and Help menus on the form. i'm coming from Java where i know getting a menu on a GUI is possible, but i haven't seen any resources for it in VBA Excel Userforms. is it possible to place menu items in a userform?

View 4 Replies View Related

Why Delete Menu Items Before Closing?

Oct 23, 2008

Came across an example in a VBA book, wrt adding custom menu items. This example included code for deleting the menu item before closing the workbook.

Is there a reason you'd want to do this? The example already had provisions to delete the menu item if it already existed before the code ran, so you wouldn;t end up with multiple items...

View 7 Replies View Related

Moving Personal Items To TOP Of Menu

Dec 30, 2008

One can create additional menu items for the right click, and these will show up always at the bottom. Is it possible to force them to appear at the top of the menu list above cut? This is specific to Macro created items.

View 4 Replies View Related

Dynamically Adding Menu Items

Jan 22, 2010

I have created a menu called "Temp" and a sub menu called "Temp1". When the user click on Temp1, I need to dynamically add some menu items under Temp1. Is this possible in Excel?

I need to do this on the right click menu. for example, along with "Cut", paste" etc menu's I need to add a Menu Item, Temp and under this menu, I need to add a SubMenu, Temp1. When the user click on the Temp1, I need to populate the child items.

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

Menu Items Disabled While In Formula Bar

Oct 3, 2007

How do I disable a custom menu item when a user is entering data in a cell?

For example... when the formula bar in Excel has focus, and a user tries to select Data > Sort, the Sort item is disabled. But when the focus is back to the worksheet, Data > Sort is enabled.

I need to do the same thing for my custom menu items.

View 5 Replies View Related

Disable Menu Items In 2007

Jan 24, 2008

How can I disable the SAVE and PRINT options under Office Button, in excel 2007??? I've tried a macro that I used in 2003 version, but it not works (problem: "File" menu)!!!

View 2 Replies View Related

Multiple Menu Items Under One Heading 2003

Jun 23, 2009

I've got several add-ins that I'd like the end user to install and have accessible under one menu item ("Assessments") in Excel 2003. So far, the code below successfully adds the item, but it only shows the item of one add-in. How can I get it to show all the items under the "Assessments" category?

Private Sub Workbook_Activate()
Run "AddMenus"
End Sub

Private Sub Workbook_Deactivate()
Run "DeleteMenu"
End Sub

Sub AddMenus()
Dim cMenu1 As CommandBarControl
Dim cbMainMenuBar As CommandBar
Dim iHelpMenu As Integer
Dim cbcCutomMenu As CommandBarControl

View 9 Replies View Related

Disable Save & SaveAs Menu Items

Jul 13, 2006

Is there a code or a way to make it impossible to make permanent changes to a file without first saving it as something else? I have a master report that is done monthly.

I do not want anyone to be able to save any changes on the master report. How do I go about disabling save and the save as funtions in excel? I have a save as command button that I only want people to use.

Also is there a way to set up a print command button to print to any computers default printer? I have set up a print command button on my computer and it works fine on mine, but I have sent the file to another person and the button is not doing anything on their computer. I assume because we don't have the same computers.

View 6 Replies View Related

Items Greyed Out On Sheet Right Click Menu

Jul 11, 2007

I cannot figure out why this setting has changed. When I right click my tab worksheet in Excel to copy or rename, it does not allow me. I will need your advice to re-activate that options so it is visible and not gray. I tried in the VBA workbook properties settings with no luck and also Tools, Options.

View 6 Replies View Related

Excel 2010 :: Installing Dropdown Menu Straight Onto Quick Access Toolbar?

Jan 31, 2012

Is it possible to install a dropdown menu straight onto the Quick Access Toolbar in 2010?

Tried

Code:

Application.CommandBars("Quick Access toolbar")

To reference it, but no joy.

View 3 Replies View Related

Sample Code To Add/delete Custom Menu Items

Feb 22, 2007

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

View 3 Replies View Related

Login Form - User Access

Jun 4, 2014

I have a userform (Login), which allows you to login by entering your username, password and by selecting your role.

When you enter the username, password and role and click on submit, it shows another userform (Activities).

Now what I want is, when i enter username, password and select the role as team manager and click on submit, it should show the userform - "Manager_Login". For all other roles, it should show the userform - "Activities".

The usernames, passwords and roles are on the sheet - "User Access".

View 3 Replies View Related

Restrict User Access To Worksheet

Dec 6, 2007

I am creating a spreadsheet for work - I have a column that is all the formulas projected sales minus actual sales.

I need to lock this column so that no one BUT MYSELF can change the codes. In other words "idiot proof" the worksheet. there are only 18 sections that I want anyone else to be able to type in.

is there a way to do this without adding users? half the ppl have personal emails and half have company emails.

View 5 Replies View Related

Excel 2010 :: Allow Multiple User Access To Spreadsheet

Aug 22, 2012

We have a spreadsheet on a server location with macros. Different users will access the spreadsheet from one pc on different shifts. Is there a way to set the area as a Trust Location for all users on the PC or enable the macros in the spreadsheet to execute for all users without having to set up the spreadsheet trust location or macros for each user? I would like to have the spreadsheet accessable to any user on the PC without setting up individual access. The users can change for shift to shift.

View 2 Replies View Related

VBA Recognize Windows User Accounts And Allow Edit Access

Jul 22, 2009

I'm working on protecting a spreadsheet to where only certain people would be allowed to unprotect and edit it... I've used a standard password protection and created a userform prompting for password and unlocking the sheet, and this works fine.

On the other hand, I was interested if it's possible to write the code to where once the "unprotect" button is clicked it would seek User Account name from windows and try to match it with a list of users somewhere within the workbook. This way the user wouldn't be prompted for a password, but rather the unlocking would simply work or not depending on user account.

View 9 Replies View Related

Combine Rows With Similar Info In Dropdown Menu Or Selection For User

Nov 29, 2012

I have a spreadsheet that has a long list of charges... some of those charges have multiple codes attached to them... when this happens I am wanting to group them together and let the user pick which one they want to view at one time.

Here is a very small example of what exactly I am referring to... with charge #14 I am wanting it to combine and let the user pick between 2565 and 2566. The problem is that the values can range and will not always be 2565 & 2566 and there is 10,000 + records similar to this.

test.xlsx

View 1 Replies View Related

Disable User Access To Master Sheet Through Doubleclicking Locked Linked Cell

Feb 23, 2010

I have a master spreadsheet that houses most of the information that remains in my control, and several other user spreadsheets that update cells from that master through links.

I am having some problems lately with users doubleclicking the locked linked cells in their workbooks, and excel then wanting to open and give the user access to my master spreadsheet. Is there a way to disable this feature? I would like it to not even acknowledge the action if that's even possible because it confuses them as to why they are getting a prompt to open another document.

View 5 Replies View Related

Exclude Items In Dropdown Based On User Data

Jul 10, 2013

I'm trying to set up a diet/training spreadsheet so that when a client enters foods and exercises they don't want/can't do, those foods and exercises are made unavailable in dropdown menus (on my programming sheet) so that I can't inadvertently put them into their plans. I have a webform they fill out, which automatically puts the data into a spreadsheet and I know how to pull data from there into the clients' workbooks...

View 2 Replies View Related

User Forms Saving Items Entered To Memory

Feb 16, 2010

Is there a way to save items into memory to be recalled in userforms.

Let's assume that I have a userform called UserForm1 and three textboxes named TextBox1, TextBox2 and TextBox3.

View 9 Replies View Related

Allow Items To Be Added To "cell" Shortcut Menu

May 19, 2007

I am using the following code to add an item to the right click " cell" shortcut menu.

I placed it in a Worksheet_Activate module in ThisWorkbook. I'm pretty sure the code is correct but it seems something is preventing the code from executing properly because no item is added to the menu. Is there some setting in a workbook that might prevent changes to the right click menu from being made? How can I get this code to execute properly?

'Set NewItem = CommandBars("Cell").Controls.Add
'With NewItem
' .Caption = "MACRO1"
' .OnAction = "MACRO1"
' .BeginGroup = True
'End With

View 7 Replies View Related

Lookup (counts The Number Of Items Which Match Criteria Set By The User)

Aug 30, 2009

=LOOKUP($C1,$A1:$A1,$B1:$B1)

Though i wanted to rid the Na error from it when C is blank

I seen a few ways, And wanted to try the method of using Countif becouse it can be used withen the same cell without using extra cells like another method i seen "=IF(ISNA(A1),0,A1)"

what i know of countif
This function counts the number of items which match criteria set by the user.
=IF(COUNTIF($A1,"")),LOOKUP($C1,$A1:$A1,$B1:$B1),"")

so how the heck can the countif function be used to rid the NA of a lookup. i just cant see a relationship between counting a lookup.

View 5 Replies View Related

Macros Not Visible: End User To Be Able To Run The Report Multiple Times By Choosing The Name Of The Macro From The Macro Menu

Jul 16, 2007

I have written two VBA programs around the same time. Both run on open and pull external data and create graphs. My problem is that I want the end user to be able to run the report multiple times by choosing the name of the macro from the Excel macro menu (i.e. Tools>Macro>Macros) but only one of the workbook macros shows up on the menu. why the other macro is not visible on this menu???

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

Programmatic Access To Trust Access To Visual Basic Editor

Jan 10, 2007

I am Generating Excel file with Macro using my asp.net (c#) application.

I am able to generate Excel file in development environment, but in Production it gives following error:
"Programmatic access to Visual Basic Project is not trusted Line: Microsoft Office Excel"

I did googling a bit and found that I have to open Excel file physically make few security related changes in macro as below.

1. Open the Office application in question. On the Tools menu, click Macro, and then click Security to open the Macro Security dialog box.
2. On the Trusted Sources tab, click to select the Trust access to Visual Basic Project check box to turn on access.
3. Click OK to apply the setting. You may need to restart the application for the code to run properly if you automate from a Component Object Model (COM) add-in or template.

Can i do above changes at runtime (using some code)?

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







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