Disable Right Click Pop Up Menu
Aug 26, 2007
Question regarding the disabling of right mouse button click options and have used the code below to disable and reciprocal code to enable options. The code works well in Excel 2003 but have recently used the spreadsheet in excel 2000 and the code causes a runtime error 5 'Invalid procedure call or argument'. how to amend the code to have it also work with Excel 2000.
With Application. CommandBars(" Cell")
.Controls("Cut").Visible = False
.Controls("Paste Special...").Visible = False
.Controls("Insert...").Visible = False
.Controls("Delete...").Visible = False
.Controls("Clear Contents").Visible = False
.Controls("Insert Comment").Visible = False
.Controls("Format Cells...").Visible = False
.Controls("Pick from drop-down list...").Visible = False
.Controls("Format Cells...").Visible = False
.Controls("Add Watch").Visible = False
.Controls("Create List...").Visible = False
.Controls("Hyperlink...").Visible = False
.Controls("Look up...").Visible = False
End With
View 3 Replies
ADVERTISEMENT
Feb 7, 2014
I wonder if it is possible to make a macro that right clicks a cell and then chooses a option from the list?
View 11 Replies
View Related
Jun 1, 2007
I need to disable the "save as" file menu command when a user opens a shared document. Upon exit I want to enable the save as so that other opened worksheets are not affected. This code works: CommandBars("File").Controls("Save As...").Enabled = False
My problem is this. I can activate this command by selecting run in the VB editor.
But I need for this action to be automatic when a user opens the worksheet. I did this in the editor:
Under general
Sub dISABLESAVEAS()
CommandBars("File").Controls("Save As...").Enabled = False
End
Sub WORKSHEET_BEFORECLOSE()
CommandBars("File").Controls("Save As...").Enabled = True
End
View 2 Replies
View Related
Mar 9, 2009
i have 2 macro icons.
i want to disable the icons after its clicked once.
View 12 Replies
View Related
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
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
Feb 27, 2007
Is there a way to either hide or disable the worksheet menu bar on ONE SHEET ONLY, so that a right-click customize doesn't even work on that sheet. I want the user to be able to do nothing but what my customized toolbar allows on that sheet.
View 5 Replies
View Related
May 23, 2007
Is it possible to disable or grey out the windows options in the Tools>options tab?
View 9 Replies
View Related
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
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
Aug 2, 2007
I would like my custom menus to act like builtin menus - specifically I would like them to be disabled (grayed out or even entirely removed) when the application is in Cell Edit Mode (I cant believe I am the first to ask about this but I cant find the answer elsewhere).
It sure seems confusing to offer users access to a seemingly active command when it does not run (in edit mode I mean).
I send huge lumps of Karma to any willing to share ideas or solutions.
View 3 Replies
View Related
May 1, 2007
Need code or way of disabling the Right Click feature in Excel? I think you can change it in the computer settings but I only want to disable it for a particular workbook so I am hoping there is a VBA Code that will tell the user "Right Click Not Allowed, Please use Cut and Paste or Ctrl +V and Ctrl +C"
View 9 Replies
View Related
Jul 17, 2007
I would like to completely disable the drop down list on the right-click.
I've got
.CommandBars("Cell").Enabled = False
set up and this works on cells but it still leaves it working on shapes.
.CommandBars("Toolbar List").Enabled = False
is similar. Anyone know how to fix this?
View 9 Replies
View Related
Mar 17, 2008
I have a workbook with multiple charts in and will be available to others to use but I want to disable the ability for them to be able to right click on a chart and make any alterations. I cannot lock out the page due to other things that I have going on. I also need to reverse this code when they close the workbook down so it does not affect any other workbooks
View 2 Replies
View Related
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
Jul 29, 2009
I want to be able to give my application menu when the user right-clicks on a specific series of cells. I've already got the code that will limit the right-click options to the cells that I want.
How do I then form and execute the menu that I want the user to see - "Archive Data", "Edit Data", "Add Data", for instance, rather than the normal right-click menu?
View 2 Replies
View Related
Mar 21, 2007
I have been modifying the options available on my right click menu, getting rid of about half of what was there and adding items I use quite often like Paste Values, Paste Formats, Paste Formulas, Sort..., AutoSum, and Format as Percent, as well as adding group dividers. I have it just the way I want it, but I have one issue. If the clipboard is empty, all of the paste buttons are disabled on the Standard toolbar and in the Edit menu as are the Paste and Paste Special... items on the right click menu, but the new paste items I added to my right click menu are still enabled. If I click on one, I get a "PasteSpecial method of Range class failed" error because I have no range selected. I got around this by adding On Error Resume Next to the macros of my added paste functions - not elegant, but functional. Is there a way to have those items appear grayed out and disabled on my right click menu when the clipboard is empty as opposed to my current workaround?
View 9 Replies
View Related
Jan 18, 2008
I have acquired code to add an item to the right-click menu.
I have added my item using "before:=1", which works fine by putting the item at the top of the list of items in the menu.
My problem is that I require to add the same item ( obviously with a different name ) that needs to be at the bottom of the list.
The reason being, that the pop-up can either display downwards or upwards and I want the user to be in closest proximity of the item.
if it possible ) to add an item to the bottom of the list.
The line I need to change is:
CommandBars("Cell").Controls.Add(Type:=msoControlPopup, before:=1).Caption = "MyMacros2"
View 3 Replies
View Related
Dec 17, 2008
Is it possible to disable the ability to right click on a tab and select "move or copy"?
I've already disabled the Edit->Move or Copy Sheet... feature on the menu.
I'm sending a file to users that I don't want them to print. The workbook itself has the print function password protected and copy/paste disabled. Any help would be appreciated.
To clarify I already have the printing part solved, but I don't want them to be able to move or copy the tab or tabs to a new workbook and print from there.
View 10 Replies
View Related
Jul 10, 2009
When we double click between two cell it goes to the last entered cell. I would like to disable this through a macro. Can anyone pls provide me a code to disable this.
View 3 Replies
View Related
Jan 31, 2007
I need to display Excel Sheet in a Browser and I want to disable the Right Click and Menu of Excel(File, Edit).
So in the method Workbook_Open i coded following
Private Sub Workbook_Open()
Application. CommandBars("Worksheet Menu Bar").Enabled = False
Application.CommandBars(" Cell").Enabled = False
Application.CommandBars("Sheet").Enabled = False
Application.CommandBars("Ply").Enabled = False
Application.CommandBars("Row").Enabled = False
Application.CommandBars("Column").Enabled = False
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Worksheet Menu Bar").Enabled = True
Application.CommandBars("Cell").Enabled = True
Application.CommandBars("Sheet").Enabled = True
Application.CommandBars("Ply").Enabled = True
Application.CommandBars("Row").Enabled = True
Application.CommandBars("Column").Enabled = True
End Sub
It works fine, but if I open Excel application before viewing this HTML page(which contains XLS) and then the option are also disabled in Stand alone Excel application. I want to disable option when for this Sheet which is opened.
View 2 Replies
View Related
Aug 24, 2007
way, using VBA code, to disable/enable individual shortcut menu items that are are made available with a right mouse button click. The following code disables the right mouse button completely but I would like to disable only a couple of options like the ' Cut' option.
The code to disable is below and to re-enable I just change False to True.
Dim cb As CommandBar
i = 0
For Each cb In CommandBars
If cb.Type = msoBarTypePopup Then cb.Enabled = False
Next cb
View 9 Replies
View Related
Dec 10, 2009
I created a right-click menu for userform textboxes from a code I found through googling. It works perfect, however, I don't know how to get it to work for more than one textbox.
Here's the code for the userform:
View 10 Replies
View Related
Dec 26, 2010
I made custom menu with these instructions: [URL]....
Problem is that when I right click my makro keeps copying itself. Ten times right click=ten my macro in the right click menu. It means that
Private Sub Workbook_Deactivate() doesn't work as it should be?
View 2 Replies
View Related
Jul 11, 2014
Is it possible to create a menu that could be called by a double click which would allow you to click on a value from that menu and insert it into the double clicked cell. I know I could use a data validation list, but that is tacky and you have to scroll down the list to find the data you would like. I'd like to have a menu pop up that stores different values in 6 columns and 25 rows. Any way without having to jump into an access database?
View 2 Replies
View Related
Apr 15, 2007
I must have disabled right click on the forms button. I usually associate a macro with the button but the menu disapeared. How can I get it back.
View 9 Replies
View Related
May 5, 2007
I've run into this really strange problem with my right click menu (popup command bar) The UF that handles the cb is loaded at workook open event and it's modal*
When first right click, the commandbar is invisible, but it's there. Only shadow seems, and when click on arrow, starts showing menu. I could say that something like repaint needed. If i click on anything, next time it popups normally !!
The problem does not occur if:
1) i load the uf manually
2)* display the UF modeless
View 2 Replies
View Related
Aug 9, 2009
I have few questions,
1. why the "auto sum" icon grey out, and doesn't work.
2. when I right click the sheet, the menu doesn't show up.
3. Insert columns/rows, When I highlight 2 columns/rows, right-click the mouse & the menu doesn't show up for me to choose insert col/row.
View 9 Replies
View Related
Dec 30, 2009
Right click menus are a well known topic but I am struggling to find information on what I want to do with them. I have seen it done so I know its possible. What I want to do is completely replace the right click menu with my own custom one on a worksheet.
I do NOT want to add things to the existing right click menu I want to effectivly disable the existing one and put on my very own one in its place. I have looked at the code for adding a menu to a textbox etc which seems sound but I can't trigger it with an event. I don't have any code to show Im afraid as I am just playing with other people at the moment trying to get it to work.
View 9 Replies
View Related
Feb 12, 2007
I have a list box with items. When I stay on item and press mouse right click, I want see pop up menu with "remove this item" and "add new item".
View 8 Replies
View Related
