shortcut key

I have created a simple macro code and assigned a shortcut key from Macro option (ctrl+Z) and it worked like a charm but when I am using iRibboncontrol then Shortcut key not working. My code given below - '''''''''' 'In Previous code and shortcut key worked well Sub HideAllExceptActiveSheet()...

Hi, I have workbook that I would like to bring to the foreground and activate when I press an assigned shortcut key (even if the workbook isn't active - .i.e minimized or hidden behind other windows) My goal is for the user to be able to bring the Excel workbook up with the shortcut key even if...

Hi, I have workbook that I would like to bring to the foreground and activate when I press an assigned shortcut key (even if the workbook isn't active). The idea is that the workbook could be minimized, hidden behind other windows, or visible, and when the shortcut key is pressed, it will...

I have 2 Excel workbooks open that both have macros. When I use the shortcut key to run a macro while in workbook 2, the macro from workbook 1 (the 1st workbook that I opened) runs. Why is this happening and how can I ensure that Excel runs the macro from the workbook that I'm in? Thanks, in...

Hi Friends You may get the complete shortcut keys for Microsoft Excel 2016. hope you like it. These Microsoft Excel 2016 keyboard shortcuts will help you become a spreadsheet master |

First I am very much a amateur and I am attempting to create a multiple choice test in excel 2010. I have the formula and macros down. My problem is there are 218 questions with 3 choices per question and it seems that I can only use 52 shortcut key combinations. Is this correct or is their...

Hi all, I'm a new member here and pretty new to Excel macros, in general. I created a very simple macro in Excel 2007 to copy the values from one fixed row to the current active cell (code is shown below). I've used other simple macros with keyboard shortcuts but it seems as though this...

Hello all - Here's my situation: I recently installed an add in called "Stock Quotes for Excel" created by a company called Technitya in an effort to replace the MSNStockQuote add in that is no longer supported. The MSN add in was incredibly valuable because it allowed us to customize all of...

Hi Everyone, It's been awhile since I've posted here but I always get the answer I'm needing so I hope someone can help me with this one. I'm trying to assing as shortcut key to an already-existing macro in my Personal.xlsb workbook. I would like to execute this macro in other workbooks using...

Hi NEED TO CREAT HOT KEYS FOR KEYBOARD IF I PRESS A THEN 1 need to paste $#a1, then 2 need to paste $#a2, again B THEN 1 need to paste $#b1, then 2 need to paste $#b2, this is the chart what i want if press A or B or C or D then 1 need to paste the code in word...

Is there a shortcut key I can use to move to the next worksheet without using the mouse? In addition is there an easy way I can move to the next worksheet in a workbook whilst still having the previous one selected? I have a spreadsheet with 300 worksheets on it that I am needing to delete...

Hello, I am working with this spreadsheet in 2007 with some formulas & conditional formatting. The short key CTRL+SHIFT+A to update the spreadsheet does not work in this version. I have an earlier version of this file in 2003. When I have both the older & newer version files open...