How To Get Rid Of Duplicated Shortcuts On Right-click

May 17, 2009

I've created a calendar in VB following the instructions in this link - [url]

The calendar works fine but the problem I've got is I've got unwanted copies of the shortcut when I right-click. If you scroll down the URL, right at the bottom in blue is a paragraph that describes the problem and how to get rid of it. I've tried this numerous times but the duplicate entries keep re-appearing.

I've attached my workbook in the hope that any of you experts would be so kind as to take a look and offer any help or advice on how to fix this problem?

View 10 Replies


ADVERTISEMENT

Shortcuts To Macro With VBA

Jan 28, 2012

Macro2 is in ThisWorkbook.

Code:
Application.MacroOptions Macro:="Macro2", Description:="", ShortcutKey:= _
"d"

How to do the above when this workbook is not active workbook.

View 9 Replies View Related

Desktop Shortcuts Done By VBA

Sep 11, 2008

Anyone know if you can place a shortcut on the desktop using VBA code?

View 9 Replies View Related

Add Shortcuts To My Existing Macro

Apr 28, 2009

I have a routine that by clicking one button, that calls a macro, that currently opens Excel, or Word, or WordPerfect. The following macro uses a Case Statement looking at what the extension is, such as for Excel . . . xls

I have added a case statement for a shortcut . . . exe

View 4 Replies View Related

Find And Edit All The Shortcuts

Jan 3, 2007

Is there a way to find and edit all the shortcuts I created in one (and in more then one) Excel spreadsheet?

View 2 Replies View Related

Keyboard Shortcuts For Existing Macro ?

Dec 30, 2008

Some expert users can unhide a sheet in a worksheet which is protected by password. But I don't want to place a button in the worksheet for everyone to see and wonder what it's for. I can record a macro and assign a keyboard shortcut but I can't do it it with existing macros ?

View 3 Replies View Related

Shortcuts For Moving Tabs To Different Files

Mar 5, 2013

Shortcuts for moving tabs to different files. A copy of the tab, I mean.

View 1 Replies View Related

Creating Keyboard Shortcuts In Excel

Apr 24, 2012

How can I create keyboard shortcuts in the easiest way.

E.g.: I would like to create my own shortcut for "Merge".

View 6 Replies View Related

Excel 2010 :: Reset Keyboard Shortcuts

May 16, 2012

unknowingly i must have deleted some shortcuts via VBA code.

now, the shortcut key (excel 2003) Alt+Insert+Row works!

But, Alt+Insert+Column does not! this works in my colleagues computers which also have Excel 2010.

is there a way to reset all keyboard shortcuts on my computer? i have tried in vain to find a solution but not found one option.

View 4 Replies View Related

Navigation Through Spreadsheet Using Shortcuts - Not Range Names

Sep 10, 2009

I currently have a navigation menu with 9 options however these options are based on Range names that I have set up.

The concern is that if someone deletes the cell that contains the range name, obviously that option in the navigation won't work, nor would you want it to.

However if someone re-enters a cell that you would want linked up with the navigation there's a lot more action involved.

What i'm looking for is a macro that can be used through a button, Idealy i'd like the macro to search through column "B" and look for key labels (ex: "Ground Floor", "1st Floor" "2nd Floor" etc.) and have each button set up for it's respective search data (ex. Ground button searches only "Ground Floor")

View 10 Replies View Related

Macro To Right Click A Cell And Select Item From Right Click Menu?

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

Add Duplicated Data

Dec 2, 2009

i am using the following formula to extract data quantities of items from a worksheet:

HTML Code: =IF(ISERROR(VLOOKUP(A9,OS_SALES_ORDERS,3,FALSE)),0,(VLOOKUP(A9,OS_SALES_ORDERS,3,FALSE)))

is there any way i can modify it so that it adds the qtys of the items which have duplicated item nšs?

View 4 Replies View Related

How To Avoid Duplicated Results

Jul 22, 2014

Transferring Multiple Data from separate worksheet without duplicating"

As you can see i am looking for information in column d (Letter) and getting the result to show from column B (number) using the formula in Column G (result 1).

The problem i am having is that if i try to copy or drag the formula down into Result 2 i just get the same answer.

Is there any way for the next cell down to ignore the previous result?

View 14 Replies View Related

Countif Exclude Duplicated Value

Sep 18, 2013

I would like to know how to set the formula to exclude duplicated value under "Countif" function.

My case is:
Section Supplier No.
D-19999
D-19999
D-1PH59
D-1PH59
D-2PW13
D-2PW34
D-2PW14
D-2PW14
D-2PW14
D-2PW14
D-2PW14

My expected result:
D1 = 2
D2 = 3

View 3 Replies View Related

Delete ALL The Data That Is Duplicated

May 11, 2007

I have data like this a column
0
1
1
2
2
3
4
5
5
5
6
7
8
9

I need to delete ALL the data that is duplicated such that the column would read
0
3
4
6
7
8
9

I am aware of the advanced filter feature that shows only unique data - but that still doesn't completely eliminate the duplicated data.

View 9 Replies View Related

Check Duplicated Data

Mar 23, 2008

I am looking a program to check if any data be duplicated to avoid any mistakes.

There are many program for duplicate check but they all only compare the cells but not to check the data within any cells one by one.

Is there any program to check the duplicated data in the selected column, columns or cells?

View 9 Replies View Related

Duplicated Vaues In 2 Columns

Apr 11, 2009

COLUMN CCOLUMN DCAST NUMBERIDAISLECAST NUMBERIDAISLE99909100DUPLCATE999091019990910299909103999091049990910599909100DUPLCATE

Example: i can have the same number repeated in column C & the same number repeated in column D But numbers in both column can not be repeated on the same row
Values are added in columns C & D sheet2 by userform combobox . i am looking or a messagebox warning when = cell values in both column are found.

View 9 Replies View Related

Vlookup With Duplicated Data

Sep 6, 2006

I seem to having a problem with my spreadsheet using Vlookup. It's mainly because on the 1st column, there are items which have duplicates and are differentiated only by the 3rd and 4th column.

example:

1st column:
Bob
Jane
John
Bob

3rd column:
Red
Orange
Purple
Blue

4th Column
1
2
3
4

Basically I'm doing a vlookup and but i want to combine (or sum) the 4th column values of Bob (Red) and Bob (Blue). I know I could use the SUMIF function in order to do what I want but I was wondering if I could nest that function within the vlookup so that it would do it automatically?

View 9 Replies View Related

Sum By Name & Other Criteria, Where Names Are Duplicated

Nov 30, 2007

I have a workbook that consists of three sheets. One is the "Master", which is were all raw data is entered. The second is a "Criteria" sheet that has a series of dates, which is later reference in my SUMPRODUCT formula and the last is a "Summary" sheet; this sheet basically summarizes all the employee data with multiple criteria. This is the sheet references both the MASTER and the CRITERIA sheets. BTW, I posted a similar thread about this here: Summarize Totals from Multiple Worksheets. I took the advice and started fresh....

My issue is that on the master, there will some employee names that are almost identical which causes problems with my SUMPRODUCT formula. This is the formula I'm using. =SUMPRODUCT((LNAME=$A6)*(DATE_CHK>=Criteria!B$5)*(DATE_CHK<=Criteria!C$5)*(SUM_RNG))

Obviously, there are named ranges. As you can see the first item in the formula references the name (LNAME). This uses the employees last name. The problem is that we have many employees with the same last name so my totals are off. I've attached a sample to better grasp what I'm working with.

View 8 Replies View Related

Restrict Macro Keyboard Shortcuts To The Workbook Containing The Macro

Sep 30, 2006

I've created Keyboard Shortcuts to run Macros in "Workbook A". Problem is, if I have "Workbook B" open in the same Excel instance/process as "Workbook A" the Keyboard Shortcuts will run the Macros in "Workbook A".

Is there a way to restrict the Keyboard Shortcuts to only run the Macro if Workbook A is active?

Or is there a way to code the Macro to run its procedures only if Workbook A is active?

View 3 Replies View Related

Duplicated Cells With Date Format?

Aug 19, 2013

I have an application that generate an excel sheet for me. In this sheet I have multiple rows with duplicated dates and text. With VBA I need to clear the content of all the cells that contain duplicated date and keep just the first row.

View 3 Replies View Related

How To Remove Duplicated ID But Have Them Add Up Values ID Represented

Jul 28, 2014

Remove duplicate but add values.xlsx

I have about 800 records and the the unique identifier are the names. Some owners are repeated several times and they have different values for the EDU column in my project. I need to remove any duplicated owners but I need to add up the values of each record that had value so I can get a combined value for one owner instead of a repeated owner with smaller values. How would I go by doing that? A formula or is there a tool in excel? I am lost on this one. I uploaded a sample file so you can see what I trying to do.

BTW i found if the values are the same for the EDU then I can not add them since it is also duplicated. I can only add up the unique values for the EDU.

View 14 Replies View Related

Two Sheets - Deleting Duplicated Data

Jul 24, 2013

I have two sheets. One of them has a long list of numbers and the other one has a shorter list, all of which are also on the first sheet. How can I automatically delete the second sheets numbers from the first sheet?

View 7 Replies View Related

How To Delete ENTIRE Row If Only One Cell Is Duplicated

Jun 15, 2011

I have a file with 238 rows and 10 columns (see file attached) Column G include phone numbers, some phone numbers are duplicated.

How can I use a macro (I must do it with a macro) to delete the ENTIRE row if the value in column G is the same in other row?

For example: look at rows 2 and 3 : the value in column G2 and G3 is the same, therefor delete row 3

(and if the value in G4 was also the same, then delete also row 4, and so on..)

View 10 Replies View Related

Move Duplicated Cell Into New Column

Mar 14, 2014

Basically I have an export which I need to manipulate so I can do a mail merge. I've managed to find a solution to remove the data I don't need and also managed to create the mail merge (even fixing the weird American date issue)

The data that is left looks a bit like this

Staff ID
Name
week ending
week ending
1
Bob Smith
02/03/14

[Code]...

basically what i need the macro to do is to see theres two Bob Smiths (or 2 Staff Id's "1") and put the second instance in column 4

e.g.

Staff ID
Name
week ending
week ending
1
Bob Smith
02/03/14
09/03/14

[Code]...

in some instances there could be 20+ week ending dates to go into the row.

also I don't need to have the dates all in seperate boxes, I just need the information in a row so the mail merge reads and sends out one message rather than 20 messages to the same person asking for each week by itself.

I've manually moved the dates into the boxes up to now and everything else is working

View 5 Replies View Related

Delete Both Rows If Data Is Duplicated

Oct 26, 2009

I have a worksheet with that I need to delete both rows if the data in one of the columns is the same. I know how to delete the duplicate row, but I need both rows deleted..........

From the example above I would want Rows 1,2 and 10,11 and 12,13 deleted based on the data in column D

View 2 Replies View Related

How To Compare Values Of Duplicated Entries

Dec 18, 2013

I manage messaging server farm that keeps mailboxes and their replicas on different servers for resilience. I need a way to check the replication status. I try to do it by comparing their sizes. I got all mailboxes and replicas incl their sizes imported into excel (2010) and I need a way to compare them.

Like this:
name
size

John Smith
10

Mary Westwood
20

[Code] ......

My idea was to find matching pair (two records of John Smith) and compare size. If the size differs more than specific value (5% or 2MB for example) the result is true/value/colour by conditional formatting etc.

View 4 Replies View Related

Highlight Duplicated With Alternating Colors

Feb 21, 2014

I have a spreadsheet that contains thousands of rows and I need to highlight all the duplicates in Column B.

What I need though is one group o duplicates to be colored one color and then the next group of duplicates be colored a different color. I need just a 2 color banding.

My need for 2 colors is that the cells contain 9 digit numbers and there can be duplicate groups right next to each other and for the eye to distinguish a different grouping of cells I need that 2 color banding.

I have the below code that colors everything in one color. Can I be modified or a completely new code to do 2 colors?

Code:
Sub Dups()
Dim Rng As Range
Dim CL As Range

Set Rng = Range(Range("B1"), Range("B" & Rows.Count).End(xlUp))

For Each CL In Rng
If WorksheetFunction.CountIf(Rng, CL.Value) > 1 Then
CL.Interior.ColorIndex = 6
End If
Next CL
End Sub

View 1 Replies View Related

How To Avoid Vlookup Duplicated Order#

Nov 27, 2008

question about vlookup:

[FILE A]
A B C
1 Order# Start time End time
2 12345 9:00 AM 10:00 AM
3 12345 10:00 AM 11:00 AM
4 23456 11:00 AM 13:00 PM
5 34567 13:00 PM 15:00 PM

[FILE B]
I want to Vlookup FILE A, order# 12345 as the below:
start time is 9:00 AM & End Time is 11:00 AM

How to avoid Vlookup duplicated order#?

View 10 Replies View Related

Unique List Of Cells Not Duplicated

Jul 16, 2009

I need a macro that will do the following:

Range: A:A

Look for the cells that do not have a duplicate and place the number in column B.

For Example:
Column A
121
121
122
123
123
124
125
125

Result:
Column B
122
124

View 9 Replies View Related







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