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


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

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

Shortcuts To Macro With VBA

Jan 28, 2012

Macro2 is in ThisWorkbook.

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

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

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

Assign Keyboard Key To Existing Macro?

Mar 19, 2014

My macro essentially requires a deletion of the entire sheet, so I cannot run it through a button, it'd by definition be deleted. So I was thinking to run this macro through the keyboard, how to assign a keyboard key to existing macro?

View 4 Replies View Related

Adding A Keyboard Shortcut In A Macro

May 6, 2007

How can i add a keyboard shortcut in already saved macro. Is there any way to do it or need to write a new macro?

View 2 Replies View Related

Attach Macro To Single Keyboard Button?

Apr 13, 2014

I have two sheets that contain data and I have to switch between them all the time, and I thought I could make it easy by assigning the "switch" to a macro. I am now looking to assign that macro so a single button, like the "`" key. I have tried various pieces of code but none of them worked.I think something like the below may work but I don't know how to start.


If Sheets("Sheet2") is active, then call switch 1, to switch back.

View 8 Replies View Related

Keyboard Keys Are Not Working After Running Macro

Jul 24, 2014

I used keypress code in one of forms, after running following command non of my keyboard is working in excel. When I am restarting excel everything is fine. what could be the reason?

View 7 Replies View Related

Sendkeys Macro Will Not Start With Keyboard Shortcut

Aug 18, 2014

However, I have not been able to find a solution. I created 2 macros that work using the alt+F8 and enter option as well as the run from the macros menu method. Whenever I try to use the keyboard short cut eg. Ctrl+e it will either not do anything or pause and then select every cell. The codes are below:

Sub Macro5()
' Macro5 Macro


I have tried multiple letter options and have also tried many macros in a new workbook and I cannot get it to run with the keyboard shortcut.

View 10 Replies View Related

Replace Keyboard Shortcut For Macro Dialog

Jul 19, 2006

I would like to replace the keyboard shortcut for the macro dialog box
The standard Alt + F8 is on the right side of the keyboard

I would like somethine of the left side such as Alt + Q

View 3 Replies View Related

Restrict Macro To 2 Worksheets Of 5?

Nov 8, 2013

I have a ctrl-q key activated macro (module 2) that successfully clears specific data entry cells in forms on two identically formatted sheets. How do I prevent access to that macro on the remaining three sheets of five in the workbook?

View 2 Replies View Related

Restrict Cell Value Macro

Dec 19, 2006

I have a range B1 to B4 for user to input value. Worksheet Change Event

However, the range B1 to B4 should not accept any value if the cell on the left hand side is empty.

If A1 is empty, B1 should not accept any value.
If A2 is empty, B2 should not accept any value.
If A3 is empty, B3 should not accept any value.

Below code checks for condition in A1 only.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("B1:B4")) Is Nothing Then

If IsEmpty(Range("A1")) Then
MsgBox "Please input something under column A."
With Application
.EnableEvents = False
.EnableEvents = True
End With
Target.Offset(0, -1).Select
Exit Sub
End If

End If

End Sub

Eg, If I enter something in A1, B2 would accept a value which is not what I hope to achieve. It should be checking for cell in A2 whther it is empty.

Would be grateful for some advice on how to modify the code.

I attached a sample file for reference

View 7 Replies View Related

Restrict Macro To Run N Times During Specified Period

Apr 17, 2013

Is there a way to restrict a macro to run only a specified number of times during a user designated time period, for example run no more than 3 times during a 24 hour period?

We have a macro that runs to alert maintenance personnel if a certain temperature condition is met in machinery. This condition may happen numerous times during a day but we only need to alert the mechanics once a day if the condition is true.

View 2 Replies View Related

Restrict Cell Values Macro

Nov 29, 2006

a value in a cell depending on some condition.

In the attached sample file, when A2=Fruit, A9=Domestic, A10=Orange and A11=1, B2 would not accept a value greater than 200 and there is a pop up message.

This control check works fine if a user has input "Fruit" in A2 first and input amount in B2 later.

However, if the user has input value 250 in B2 first and input "Fruit" in A2 later, 250 would be accepted by B2 and there is no pop up message.

View 9 Replies View Related

Call Macro When Clicking In Specific Cell From Personal Macro Workbook

Aug 13, 2014

This is the code I use to call a macro when the macro Im calling is in the same workbook.


However, I would like to call this same macro when using another workbook. I copied the macro "Clearformating" and pasted into a personal macro workbook module. However when I add this code to the sheet tab it will not run the macro.

I also tried this code.

[Code] .....

View 2 Replies View Related

Macro Disable/enable Still Appears After Macro Deleted From Workbook

Oct 3, 2006

I have a question concerning Macros and the Disable/Enable prompt. My boss has a spreadsheet which has been used for years and he recently wanted to and did remove the macros from the spreadsheet (they were no longer necessary), but the disable/enable prompt still appears when the spreadsheet is opened. I replicated this in a test spreadsheet with a simple insert line macro and received the same results. Is there a way to remove the macros and the disable/enable prompt once they are removed? I know about setting the security to low to not see the prompt, but I would think that once the macros are deleted, the prompt should not appear any more.

View 2 Replies View Related

Open File Macro: Same Directory As Macro Workbook

Nov 17, 2006

I created folder on my desktop to hold various documents. I have master excel document which contains forms and command buttons that open documents from same folder. Is there a way to change code instead of having full file path to specify current directory. I'm worried that if I move this folder to another location then my open file button will not work since location is changed.

Also when I open with command button word document, I have a button on word document to close. I can close document but word application is still active. Can I close word application with the document at the sam time. This is the code I'm using: "ActiveWindow.Close"

View 3 Replies View Related

How To Restrict Code To Current Workbook

Aug 3, 2014

I have the following code linked to a drop down list in my workbook.


It populates textboxes on the sheet with a lookup value result, the lookup value is taken from the dropdown box. The problem I have is any other excel workbooks that are open at the same time, the code is trying to run against those workbooks when I edit them, I can't seem to restrict the code to run only against the workbook in which the dropdown box which the code is linked to, exists in. I have tried moving the code to a module in the workbook but then the code does not seem to work as it does know which workbook the combo box and text boxes which should be filled with the lookuip result belong in

Link to workbook is [URL] .....

View 5 Replies View Related

Restrict Workbook Access To One Computer

Dec 23, 2006

I wish to send a workbook but need to ensure that this workbook stays on the computer it is destined for. I understand that for ultimate security excel may not be the best option, however im using excel and with that need to look at the best options available to me.

My thoughts were along the lines of sending a simple application for better words in excel, and having the user fill in a few details, this would trigger a events macro recording A the machine id ( which i have forgotten how to do any any help would be great with that ) or B the user ID to a hidden cell, then on receiving this back be able to use that as a key in the application before sending it out.

Then if the user was to pass this to another person it would not work as the code would not match. Does this seem like a best approach or is there a better way that a similar effect could be had?

View 9 Replies View Related

Run Macro In All Excel Macro Enable Workbook

Jan 27, 2014

I want to run a welcome macro in all excel workbooks. Whenever I open any macro enable workbook the welcome macro should run.

View 9 Replies View Related

Create Macro That Won't Allow Movement With Workbook Until Macro Run

Jan 28, 2014

Writing a Marco. I would like to place a macro on the opening page of a workbook and like to a button that executes three functions.

1) I need to hide selected tabs in a workbook
2) I need to copy paste values of a couple select cells in a workbook
3) Lastly, I would like to set up the workbook so that the use can not move beyond the opening tab with out clicking the macro to preform the steps above.

Is this possible? I know 1 and 2 are for sure, what about 3?

View 1 Replies View Related

Macro To Open And Execute A Macro From Workbook

Jul 20, 2003

Is it possible to use a macro to:

1. Open Excel from the Desktop

2. Open a workbook

3. Execute a macro from this workbook

If so, how can it be done, specially point 1?

View 9 Replies View Related

Modify Existing Macro To Copy To Different Workbook Instead Of Open Workbook?

Dec 7, 2012

Here's my macro:

Sub CopyRow()'
'Copies row to new sheet, highlights it, marks column 'A' as copied.
Dim cCell As Range
Set cCell = Selection.Cells(1, 1)

[Code] .....

Is it possible to modify it to paste into a different workbook called c:filesDestination.xlsm, instead of the existing workbook (Source.xlsm)? The destination sheet name is the same (Sheet2). It's OK if both workbooks are open at the same time.

View 2 Replies View Related

Macro To Transfer All Data From One Workbook To Specific Sheet In Another Workbook

Feb 23, 2014

I have data in 2 different workbooks, and I need to transfer all data in 'Jx_ex1' to sheet1 in the 'template' workbook, and all data in 'Gr_ex1' to sheet2 in 'template' workbook. All data should be transferred to the same cell numbers, from A1 to Y5000. I actually have loads of workbooks to transfer to the template but if I have an example with the two then im sure I can work out how to modify it. All files will be in the same folder.

View 8 Replies View Related

Close And Reopen Workbook From Macro Stored Inside Workbook

Mar 30, 2007

I have a Macro that is stored in a specific workbook,"Projection Modeler.xls" the last line performed in this macro is the close workbooks without saving chages(this needs to be done due to the way this macro was written, and it would take too long to rewrite). If I would then like to reopen this workbook, and then rerun this macro, can I do this from inside the current macro (in a new sub routine, for instance), or do I have to write a macro outside of the workbook and then open the workbook and call the routine?

View 4 Replies View Related

Macro To Copy Only Formats And Values From One Workbook Into New Workbook

Mar 5, 2014

I have a workbook that has a lot of formulas in it that reference material stored on my local computer.

I need a macro that will copy all 42 tabs in to a new workbook book without all formulas, but saving all the formats have made. This would save me from every other day coping and pasting manually each of the pages.

View 2 Replies View Related

Adjust Copy Macro From Another Workbook To Print Name Of Workbook As Well?

Feb 11, 2014

I have this nice macro that copies data from another workbook. I want to make it to also add the filename of the workbook (for example data.xlsx) it copies the data from, in a cell on the actual workbook (for example on sheet "Combined", Cell A10). What should I add to my macro?

View 3 Replies View Related

Copy Data From One Workbook To Updated Workbook Using Macro

May 1, 2012

I am creating a spreadsheet to provide to a group of about 40 people. The spreadsheet allows each member to track the referrals they receive and give. I need to plan on creating updates for the spreadsheet and want to make it so they can easily transfer their data to the most current version in the future. Here is a breakdown of the workbook:

Referrals Given
Referrals Received

I need to copy the data that they have input from the following worksheets:
Referrals Given
Referrals Received

Here is a breakdown of the "Referrals Received" worksheet:
A1:V4 - Data that will not change and includes many named cells
A5:Nxxx - Dynamic Named Range where they input their data
O5:Vxxx - Contains formulas

I need to be able to copy
from the old workbook to the new

Some side items to note:
There is VBA in the worksheet of
Private Sub Worksheet_Change(ByVal Target As Range)
and included in the code is an Unprotect & Protect code to always keep the sheet protected

I figure whatever works for this sheet will work for all the sheets.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved