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.

Filter by
Sorted by
Tagged with
2 votes
0 answers
47 views

How to bind USB control knobs to adjust the volume on specific applications?

I want to control the volume level of 2 specific Windows Applications using my USB piano's control knobs (Spotify Premium & discord). FIRST TRY - AutoHotkey. The KeyHistory does not detect any ...
-1 votes
1 answer
24 views

MS Access 2016: How to delete a macro?

I use Access of the Microsoft Office Professional Plus 2016 package. I played a little bit with the Creation of Macros. I safed a macro named "Makro1". Now I want to delete that Macro, ...
1 vote
2 answers
4k views

Microsoft Access Macro - is there a way to copy records with a macro?

I have written a macro in Microst Access that runs a make-table query, opens the table and selects all the records. (I don't know VBA so I have to use macros). Then I copy all the records and ...
0 votes
0 answers
17 views

New to MacOS and trying to replicate a few things that I already do using Autohotkey on windows

Below is my Autohotkey script that automatically copies the text of any questions that I ask on the websites for ChatGPT, Gemini, and Claude (I have them installed as chrome apps) by detecting the ...
0 votes
0 answers
25 views

Mentions affecting Regex Validation

I was wondering if anyone came across the issue with Regex validation in Microsoft Outlook when including mentions (i.e.,@Tony or @Jodie). The below code works fine when there is no mentions in the ...
0 votes
1 answer
2k views

VBA EXCEL: find method not working when looping through each cell in selection

I'm trying create a macro that, after a range selection, will tell me how many 20ft or 40ft containers where found in the sample. The macro basically looks for the string "1x20" or "1x40" and when ...
0 votes
1 answer
5k views

Open an Access database with scripting disabled (macros and VBA)

Suppose you want to examine the contents of an untrusted Access database. It seems there should be a way to open it in Access with macros and VBA disabled. Searching around the web, I've found ...
1 vote
1 answer
6k views

How do I move individual letters up and down?

Let's say I have the word cake and I want to move the "a" higher and the "e" lower (about 1pt each). Is there any way to shift them up and down without messing with the paragraph ...
0 votes
0 answers
13 views

Inserting Today's Date In A Cell If Other Cell Values Are Changed or Added using VBA

So I have this spreadsheet that I share with my Team, and I'm looking for a way to have a Today's date put in a cell, everytime there's a change in the worksheet. I found this coding, which is working,...
0 votes
0 answers
9 views

Google Sheets - Recorded a Macro to Import a File [migrated]

I'm able to import a file from my disk using "File Import". I tried to do the process while recording a macro. I did "File", "Import", then chose "Upload new file&...
0 votes
0 answers
27 views

Excel Macro: Pasting Values from Sheet into a Table Error

I am trying to copy data from worksheet "Project Summary Data" and paste it into a table on worksheet "Project Cost Report Summary". I am very new to Macro's, so I am unsure of ...
1 vote
1 answer
52 views

Notepad++: Creating a macro replacing selected text

I need a Notepad++ macro that will perform search and replace, but for the portion of text that is highlighted at the moment of running the macro. I tried recording a macro, but it records for the ...
1 vote
0 answers
44 views

How to run a Word macro from the command line?

I'm trying to save and close all open Word files (to start I only target one of them). The macro I made works when ran from Word (clicking "Execute"), but it won't run when called from the ...
2 votes
1 answer
5k views

Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet. I just need it to separate the files based on a column into a separate ...
3 votes
1 answer
4k views

Quick Steps in Outlook quick access toolbar

How can the quick steps in Outlook (2013) be added to the quick access toolbar? The Microsoft forums have an (un)helpful answer. Quick steps exist on the Home tab of the ribbon in a box, but I have ...
0 votes
1 answer
6k views

Make sure Excel file cannot be saved if the column has empty cells

I want to enforce entering the values in a certain column, up to the point where there are values in an adjacent left column A. It would be ideal to avoid popups but instead, have the cell borders ...
0 votes
0 answers
31 views

Macro for compressing/expanding formulas in Excel [duplicate]

I have looked for a while but haven't come across something that does what I am looking for. I'm not that proficient in writing macros and if this isn't possible I will find a different solution to my ...
0 votes
1 answer
78 views

Libreoffice macro has infinite loop

Can someone point out what's wrong with this macro please? I'm trying to search for paragraphs with the token "vv", then change their paragraph style to "_Verse". This macro works ...
1 vote
1 answer
62 views

Macro for using Goal Seek over a range of cells

I'm trying to automate the GoalSeek function over a range of cells. Each cell in Columns I and J calculates a quantity of interest using two different methods, and the results must agree. Each cell in ...
0 votes
0 answers
18 views

Microsoft Word Global Templates Loaded from SharePoint?

I have a Macro Enabled Template I use to store my Macros and I wanted to share them with my company without having to duplicate the document on everyone's computer or changing the file path in the ...
1 vote
1 answer
5k views

VBA Function or Macro to Move Selected Message(s) to Folder of Conversation

I organize all my Outlook messages as conversations. I'm looking for a function to move the currently selected message(s) from the inbox to their respective folders. For example, if I have an email ...
2 votes
1 answer
2k views

How can I scroll efficiently horizontally Microsoft Paint? (Autohotkey maybe)

I just want to use Paint for a whiteboard style sketching on math problems etc. And I really need a way to navigate efficiently on the page. Maybe even like: hold space + move mouse, to grab the page ...
0 votes
2 answers
59 views

Use a Macro or Formula to replace a single letter with a string of text

This should be pretty simple. I want to use a formula or macro that will automatically replace a letter with a string of text within the same cell. Ex.: If I type the letter "r" in Cell A1 I ...
0 votes
0 answers
34 views

My windows excel icons are same for .xlsx and macro enabled .xlsm files

I'm running Microsoft Office Professional Plus 2016. The macro enabled .xlsm files, used to have an exclamation mark in their excel icon. For some time now, all type of excel files have the same ...
1 vote
2 answers
9k views

Keyboard Shortcut to Run Macro in Excel for Mac

Basically the title says it all. In the editor in Excel on Windows, all you have to do to run a macro is press F5. What is the keyboard shortcut to do this on a Mac?
0 votes
0 answers
16 views

How to break a paragraph with footnotes via \autocite{} into sentences in nVim?

This question is similar to the one asked here. I'm trying to figure out how to break paragraphs written in a TeX file in Nvim so that: any sentences with a citation (i.e. \autocite[][]{}) after them ...
-1 votes
1 answer
53 views

Footer page numbering restarting when using continous sections

I am using MS Office 365. I have created a Word Form, with page numbering in the footers. Some of the pages have continuous sections in them (to enable a signature line to be in an unprotected section,...
0 votes
0 answers
37 views

How to edit/create settings/shortcut/macro for enabling reversed text input direction in Windows 10?

I want to create a hotkey for the ability to insert a character without advancing the caret, i.e. write backwards. Every search I tried on Google related to this functionality is of how to disable it, ...
3 votes
4 answers
61k views

How can I avoid the clipboard message box when copying large amounts of data in Excel?

I have a macro that is copying 4 sheets from one workbook to a new workbook and saving it down with another name. Unfortunately the message box asking me whether I would like to make this large ...
0 votes
2 answers
5k views

Creating Macro to print selected cells

I am trying to record a Macro to print selected cells then return the worksheet to its original format. I am hiding columns B through H, printing A7:I68. While recording the Macro the print comes ...
5 votes
1 answer
535 views

Making it so users that do not have macros enabled cannot see other sheets

I am working on a project that wants all users to have macros enabled. It is a shared sheet so I cannot simply hide everything as a baseline and unhide the sheets when Open_Workbook is ran. My goal is ...
0 votes
1 answer
9k views

Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

I have one worksheet for setting up the data sources of multiple data validation lists. in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets. I need to ...
6 votes
6 answers
32k views

Switch speaker configuration between stereo and 5.1 using shortcut

I'm trying to find a way to quickly change speaker configuration between 5.1 and stereo in Windows 7; anything that I will be able to make a shortcut of on the desktop for quick access. The issue ...
1 vote
1 answer
4k views

Disable a macro, with another macro. EXCEL VBA

I have 7 macros that prevent a user from copying and pasting in a workbook. However, now and then I want to be able to copy and paste. Is there a way to disable these macros with another macro ? I ...
2 votes
2 answers
9k views

Transferring custom excel ribbons in local computer to other computers in Excel 2010

I have created certain Macros. By customizing the ribbon ,i converted the Macros into buttons. I saved the file as an add-in (.xlam). Now, when i send the file to other people, I shall tell them to ...
1 vote
2 answers
4k views

AutoHotKey: Pressing two keys simultaneously without repeats

Is there a way to press two keys simultaneously and bind it to a macro key (for example, pressing "s" and "d" simultaneously and then bind it to "a" key) without it ...
1 vote
1 answer
3k views

Cannot upload file to FTP from Excel's VBA

I need to automate uploading file to FTP server from within Excel's macro. I'm following a simple path of creating script file and then running FTP.exe with commands from that script file. The ...
0 votes
1 answer
77 views

Identify columns having mix of Dr and Cr values

I have an Excel file where columns E to BB have amount values, the cells of which are formatted using Custom Format as either ""0.00" Cr" or ""0.00" Dr" I want ...
0 votes
2 answers
76 views

Excel macro to split the date and time in one column to two separate columns

The code created by the macro works just fine, but looks clumsy. Can anyone assist in cleaning this up so that I can learn to make the recorded macros cleaner going forward? Sub SplitDateTime() ' ' ...
3 votes
2 answers
38k views

Can i stop a blackwidow macro while its being executed?

I'm trying to make a macro for my blackwidow keyboard, which has to be executed until i press a different button. Can anyone tell me how to do this, or how tp stop a macro from being executed halfway?
0 votes
1 answer
4k views

Trying to create a Start/Stop Timer using an Excel Macro

I'm new to creating Macros in Excel and have been trying to understand VBA by taking apart Macros others have made. What I'm trying to create right now is a Start/Stop timer of sorts to measure how ...
0 votes
3 answers
4k views

How to add VBA to MS Office installation

I am missing VBA on my Office 2016 installation (installed via Office deployment tool). When attempting to open Visual basic for Applications (Alt + F11) nothing happens. The Macros options are greyed ...
0 votes
2 answers
380 views

How to handle protected view errors in Excel VBA macro

Introduction. I have a local website, and one of its pages is used for downloading an Excel report by several users on their PCs. The file is automatically generated with some data from our database ...
0 votes
2 answers
173 views

How to add a keyboard shortcut for a macro in excel

I want to add a custom keyboard shortcut for a Macro (to zoom in and out) in MS Excel. It works very well with Word thanks to this answer, but on Excel (at least with Version 2310 that I'm running) ...
2 votes
1 answer
48 views

Separately color all rows for unique clients listed in one column

I am a relative Excel noob, and to that end, forget about Excel macros. I'm here because this seems to be where the GOATs congregate, and I really need some help. I have an enormous data set that ...
0 votes
1 answer
4k views

Auto delete a value after a certain date is passed

I'm making a work registration list for myself and my colleagues.  In this workbook I created, we have a certain amount of free days we can use, but we need to use those free days before a certain ...
11 votes
10 answers
69k views

Keyboard macro to change default audio device

Windows 7, Logitech G110 keyboard 2 audio devices (headphones and speakers) I am hoping to find a quick way to macro a key to switch to headphones, and a key to switch to speakers. Anyone have a ...
122 votes
14 answers
393k views

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 ...
1 vote
1 answer
4k views

Automatically change OneNote page background to dark/black?

I have Onetastic for ON2013, whenever I make a new page I use that addon to make the page background black/blue (000009), and then whenever I type I need to manually change the text to white. Is there ...
2 votes
1 answer
114 views

Notepad++ Recording a Macro with searches in it

I'm using Notepad++ to edit a calendar ".ics" file. I've used simply macros before but can't get this one to work. I need to find the text "cancelled", then go back 6 rows (ok so ...

1
2 3 4 5
36