Disabling Delete Sheet From Menu

Jul 19, 2007

How do I diable the "Delete Sheet" so user can not delete any sheets

View 9 Replies


ADVERTISEMENT

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

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

Disable The Delete Function From The Menu

Oct 13, 2009

I am creating a fool proof, well as near as I can get it, spreadsheet for them to work in and want them to follow the rules I set out!!

I am able to disable cut, copy, paste etc but was wondering if it was possible for to disable to use of the "Delete" function from the menu when you right click on a cell and also disable to the Delete key on the keyboard?

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

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

Right Click Sheet Menu

Sep 14, 2007

Need code to allow the sheets in a workbook to be selected from the right click menu

View 11 Replies View Related

Drop Down Menu From Another Sheet

Nov 29, 2006

I do a lot of horse racing ratings in Excel, in fact its the only way I do the form these days.

The thing is I'm always looking for ways to save time and was thinking the other day about how I enter the results.

I would like to have "drop down menus" for each of the place getters that I get from another sheet in the workbook.

Is there a way to do this? I'm using excel 2007 (which I love)

Race 1 sheet is named race1 and have up to 24 horses/names to pick from

View 9 Replies View Related

Dropdown Menu To Get Contacts In Sheet

Dec 20, 2012

i have a excel sheet which i use to estimate of course i have many contractors i use

my question is, is it possible to create a drop down menu with the contractors name and autofill the cells below with the address

Cell_B5 Company (Dropdown)
Cell_B6 111 Street Rd
Cell_B7 TownCity State 11111

or is it without a dropdown possible by just typing the first few letters and then autofill and how to do this

View 3 Replies View Related

Disable Sheet Tab Menu Selections

Dec 22, 2006

I want to disable the functions via right mouse click on a sheet tabs to workbook users.

As the programmer I may need to access these function on occasion.

My VBA is password protected to keep other users out.

View 9 Replies View Related

Drop-down Menu With All Sheet Names

Sep 21, 2006

What I am trying to do is to put a drop-down menu in a sheet which has all the names of the sheets that start with A, C and P?

Does anyone know how I would go about this?

View 9 Replies View Related

Popup Menu For Sheet Index

Aug 21, 2007

I have a workbook containing multiple sheets of data. I have a macro to analyze this data but want to add a popup menu with a dropdown list of all sheets in the workbook. The idea is to have the macro prompt me to select which sheet to continue running on. I can't remember how to create an input box with a dropdown menu.

View 8 Replies View Related

Forcing A Menu Sheet To Display On Startup

Jan 10, 2010

In a multi sheet workbook (Excel 2007), could some one tell me how to force sheet 'Main' to be displayed?

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

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

Using Dropdown Menu To Filter And Rank Off Raw Data Sheet?

Jun 19, 2013

I have one worksheet that has a list of accounts with various attributes. On a separate worksheet within the file I would like to have a drop down menu to select one attribute (i.e. category) and then once selected, have ALL the accounts with that attribute populate in a descending order based on another attribute (i.e. volume).

View 2 Replies View Related

Limiting Custom Menu Selection Based On Sheet Name

Jun 13, 2008

i am considering the use of custom menus in an Excel application. is it possible to limit the selection of menu items for each worksheet? for example, sheet 1 all menu items are available, sheet 2 all but 2 menu items are available, sheet 3 all but 5 items are available.

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

Graying Out Custom Menu Buttons When Sheet/book Protected?

Oct 6, 2009

is there a way to cause my custom menu items to grey out like the built-in ones, depending on the current selection or when the status of the active worksheet/workbook changes (e.g. when the book is protected to disallow certain actions)?

Obviously I can trap any problems once the associated VBA is invoked, but it'd be more professional if I could just prevent that from happening in the first place.

View 6 Replies View Related

Move Rows To Another Sheet When Value Is Chosen From Dropdown Menu In Cell

Nov 25, 2013

i am making a simple complaint tracking system and there is a column where there are two choices Resolved and Unresolved if you choose resolved it copies the row to the resolved sheet and if it's unresolved it copies the row to the unresolved sheet. i attached a template to give you an idea, i want the first complaint to be copied to the resolved sheet and second one to the unresloved sheet, i don't want the status column which contains the choices to be copied to the other sheets, also the unresolved sheet doesn't have a 'date closed' column because the complaint is not yet resolved so i dont want it to be copied there, i want it only in the resolved sheet.

[URL]

View 1 Replies View Related

Move Row To Another Sheet Based On Action Words Chosen From Dropdown Menu

Feb 7, 2013

I have a excel file to keep track of sales pipeline. What I am looking for, is an automated utility or code that will allow excel to automatically move entire rows once a task is completed and can be moved to another sheet. In Prospect sheet I have a column for " sales stage" and here you have to select from a drop down menu, either "Prospect", "semi-qualifed" "Pre-qualified" "verbal" "closed-won" and Lost. What I would like, is that once you have selected one of the sales stage, the entire row or entry, will be automatically moved to a new sheet according to each stage.

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

Copy Data And Sheet Name To New Sheet And Delete The Old Sheet?

Mar 30, 2014

Example, I have a sheet named DATA1, I want to add a new worksheet, copy a certain range from the DATA1 sheet to the new sheet and rename it the same name DATA1 and delete the old DATA1 sheet.

Also, the sheetname will be unknown, the macro must get the sheet name first.

View 2 Replies View Related







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