Questions tagged [macros]

A macro in computer science is a rule or pattern that specifies how a certain input sequence should be mapped to a certain output sequence according to defined rules and procedures. Consider using [vba] tag instead of this one if the question concerns a Microsoft Office product. This helps the people answering, filter questions more efficiently.

Macros refer to any sequence of events that can be programmed to execute without user interaction. There are subsets of macro types that are more specific to the program(s).

Try to reference the program your macro is used in e.g. . For Microsoft products, use . For scripts, use .

1795 questions
123
votes
14 answers

How can I control the master volume in Windows?

Some keyboards have volume controls on them that can be pressed anytime to control the master volume. My keyboard does not have that. Is there a way that I can create a key macro that will work like the volume controls on those keyboards? It…
Phenom
  • 6,767
58
votes
17 answers

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes =[WorkbookA.xlsx]!B!23 when copied over. I want to…
49
votes
4 answers

How can I record macros for Autohotkey?

I used a macro recorder for AutoHotkey in the past, but now I can't seem to find it at all. How can I record macros for Autohotkey?
Karsten
  • 898
48
votes
1 answer

How do I assign a keyboard shortcut to recorded macro in Sublime Text

I have a bunch of macros which I have recorded and saved in Sublime Text 2. I'm trying to assign keyboard shortcuts to each of those, but I'm kind of lost as to how to go about doing this, I had a look at Sublime Text 2 - Assign a keyboard shortcut…
47
votes
8 answers

How can I stop Excel from opening a second blank window when opening a file from Explorer?

When I open an Excel file from Windows Explorer, I always get a second Excel window as well. Annoyingly, when I close it, it doesn't close, but the other window does! This seems to be a common issue: Excel 2013 starts up with blank screen when…
Deanna
  • 1,184
36
votes
5 answers

Can I make an Excel VBA macro available to all workbooks?

Is it possible to write a VBA script in one workbook, and use it in other workbooks in the machine? I guess I'm looking for a way to write a macro package. EDIT Following the instruction in the link given by Lance, I managed to create the addin, but…
bavaza
  • 623
35
votes
8 answers

Mapping Super+hjkl to arrow keys under X

I'm trying to map: Super+h -> Left Super+j -> Down Super+k -> Up Super+l -> Right globally under X. The idea is I don't want to leave my home row that often to use the arrow keys, so I'll use the Super modifier + hjkl to emulate the arrow keys…
28
votes
10 answers

Is there a Win7 shortcut to position mouse in center of primary screen?

I have a three monitor set up on Windows 7 and I sometimes lose track of where my cursor is. Is there any Windows shortcut to reset the mouse position? I'm guessing there is not, but might there be a way to set up a simple macro I could bind to a…
tehDorf
  • 1,037
  • 4
  • 12
  • 20
23
votes
7 answers

What's a good macro recorder for Windows?

I'm looking for a tool that can record everything I do with my mouse/keyboard and playback recorded sessions. I've found some softwares that can replay macro using a script but none that can also record a session. I remember that my old 'mac…
Guillaume
  • 788
20
votes
3 answers

How to inspect / view an Excel macro before "enabling macros" for a sheet?

I'm receiving occasionally an xls file that contains a macro which I should use. If I don't have complete trust in the sender, I wish to look at the macro's source in order to verify that it indeed does only what it is supposed to. However, in Excel…
GJ.
  • 10,151
20
votes
3 answers

Can I search and replace in a Notepad++ macro?

I'm trying to create a macro in Notepad++ that allows me to do a few standard Search & Replaces. I can get the macro to do everything (add lines, add characters) except search and replace. I can't find the files to edit the macro manually. Has…
Konerak
  • 1,915
  • 3
  • 20
  • 29
19
votes
10 answers

How to turn hundreds of text URLs in Excel into clickable hyperlinks?

How do I turn a column of urls into hyperlinks, so that users can click on the url in a cell and have it open in a browser? I pasted 100 urls and each went into its own cell. When I double-click in the cell and then leave it, Excel turns the text…
kacalapy
  • 605
18
votes
2 answers

How to cancel recording a macro in Vim?

Imagine I had recorded a macro and then I've occasionally started recording a macro into the same register. Can I interrupt the recording so that the original macro is preserved in the register? I know that I can do :let @b=@a to copy the macro from…
Alexey
  • 403
17
votes
4 answers

vim: Continue macro after error in submacro?

I'm in the process of beautifying some source code using vim. {1} I've created a couple of vim macros that do the individual steps: removing trailing whilespace, removing empty lines after {, removing empty lines before {, that kind of stuff. Now, I…
DevSolar
  • 4,560
16
votes
3 answers

How can I delete rest of the line after a specific string?

I'm looking for a way to search for a specific string e.g. '=UUID:' and delete it and all following characters per line. I would prefer a way/macro/addon for notepad++. But all other tools or scripts are welcome :) Before …
nixda
  • 27,634
1
2 3
99 100