-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
hotkeys
-
U
Saving Macro Shortcuts to All Workbooks
Hello, I have a number of relatively simply macros that I have created and saved in my personal workbook. One of the macros assigns a shortcut keystroke to the other macros (see below with two of the hotkeys that are assigned listed). Sub SetShortcutKeys() With Application .OnKey...- UWHusky
- Thread
- Replies: 3
- Forum: Excel Questions
-
B
Changing Add-In Hotkeys/Shortcuts
Does anyone know if it is possible to change the Alt Hotkeys that select different tabs/add-ins on the ribbon bar? I have several add-ins that I am required to use at work, and I would prefer that their Alt Hotkeys weren't randomly chosen. For example, my FactSet add-in uses "S1" which is...- bkanne
- Thread
- Replies: 0
- Forum: Excel Questions
-
C
Longtime fan from the TechTV days. Have a question on applying formula to highlighted cells
Good afternoon. In my job, I receive cost invoices that I must convert over to sell invoices. Since markup is typically static across multiple lines of the invoice, is there a way for me to apply markup percentage to the cells that I highlight and replace those results right back into the cells...- CptRameus
- Thread
- Replies: 1
- Forum: Excel Questions
-
X
Hotkey to switch between sheets? - Simple Question!
Hi there,I'm trying to work out what the Hotkey is to switch between sheets in excel.For example there is Alt+Tab for switching between windows, Ctrl + Tab for switching between open internet tabs, surely there must be a way to switch between sheets in Excel too, right?Thanks in advance for any...- xyzabc198
- Thread
- Replies: 3
- Forum: Excel Questions
-
L
Excel 2007 Custom Ribbon Keyboard Shortcut
Hi, I have created a custom ribbon that has macros running through it. Is it possible to change the keyboard shortcuts/hotkeys for this custom ribbon? This could really help all my colleagues that are used to another version of the ribbon. Thanks in advance, Nana- lottrup
- Thread
- Replies: 0
- Forum: Excel Questions
-
B
Hotkey probs
Hi all. I have a colleague whose hotkeys (ctrl+c & ctrl+v) have stopped working in one spreadsheet. They work fine in others and I have looked through the xl options but cannot see why this might happen. Any ideas would be most helpful.- BugBear
- Thread
- Replies: 3
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...