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.
1,766
questions
0
votes
0
answers
34
views
How to search the web via context menu with quotation marks using only mouse?
I often drag an English phrase and search it in Google or Bing with quotation marks to find the exact expression.
Dragging with the mouse, right-clicking shows me a context menu of "Search 'the ...
0
votes
0
answers
35
views
Excel: Insert Copied Cells and pasting values only ... some of it
I'm looking for an excel expert here and what I'm asking may not be possible. Originally, I was looking for a macro to allow me to paste values after performing an insert copied cells and shifting ...
1
vote
1
answer
69
views
Excel - put login times into neat hours
I have this info in an excel spreadsheet ..
representing the amount of time spent logged in to a computer..
logins time of day amount of time logged in (h:mm)
------ ----------- ---------------...
0
votes
1
answer
33
views
Removing Content Control Quick Part in Microsoft Word
I have a VBA macro that will auto populate a document with content control quick parts that have blocks of text with other content controls within them.
I'm attempting to write a VBA macro that will ...
0
votes
0
answers
29
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 ...
-1
votes
1
answer
33
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, ...
0
votes
0
answers
28
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 ...
3
votes
0
answers
77
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 ...
0
votes
0
answers
14
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,...
2
votes
1
answer
79
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 ...
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
0
answers
91
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 ...
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 ...
1
vote
1
answer
143
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
1
answer
83
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 ...
0
votes
0
answers
31
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 ...
0
votes
2
answers
85
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
43
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 ...
0
votes
0
answers
18
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
124
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
48
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, ...
5
votes
1
answer
549
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
90
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
110
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()
'
' ...
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
2
answers
451
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
217
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
125
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
vote
1
answer
313
views
LibreOffice Calc Basic search and replace macro
I am attempting to create a LibreOffice Basic macro for use in Calc that when invoked in an open spreadsheet file will open a second spreadsheet file that contains two ranges, (the first range ...
0
votes
1
answer
46
views
Macro to keep 3 rows visible under the selected row in LibreOffice Calc
In Calc or MS Excel when one is finished editing a cell in a row, pressing Enter leads to the next row below. Keep doing that and eventually you arrive at the last row visible on the screen. Here when ...
0
votes
0
answers
345
views
How to get live data from a website in Excel
I want to get the price of an item from AliExpress in Excel.
For example, this item. I modified the URL to get the specific product variant using this.
I found this to get the name and price of the ...
0
votes
0
answers
65
views
How do I automatically generate colour styles in LibreOffice Calc using VBA?
I want to be able to run a macro to automatically create a set of named styles that change the cell background colour.
I tried this, but it doesn't work:
REM ***** BASIC *****
Sub ...
0
votes
0
answers
188
views
Execute Macro via USB device
I want to execute a macro via hardware, and not software. Ideally being OS-independent.
Here are some ideas that I've had and how far I got on each of them:
Pre-programmed Mouse. Since the macro will ...
0
votes
0
answers
32
views
Looking for common solution to validate Excel reports (ETL)
I'm trying to more efficiently validate financial reports generated in Excel.
Currently, a user generates around 300 reports in Excel using different Sheets in each. These reports use extensive ...
0
votes
0
answers
266
views
How to wait for Web Query to complete in Excel VBA Macro
I have an Excel file that uses an API to lookup some data from a website. It is built using the standard "Get Data from Web" built in PowerQuery feature of Excel. I run a macro to update ...
0
votes
0
answers
32
views
Copying a specific range of cells form multiple worksheets in a work book to a Summary Sheet
I have data on 28-31 different worksheets based on the month. the data is goes from B23 to J33. I need to copy and paste those cells from each tab to a Summary tab.
1
vote
0
answers
13
views
Trying to update ranges in macro to not have set range
I am trying to update my macro to where the set ranges in the macro are not hard coded because when the data for the new data set is ran the data range may be smaller or larger. How do I update my ...
0
votes
0
answers
118
views
Excel macro requests access to an external file: removing dependencies
I download an Excel file and I copied the sheets (I tried also to maintain only the main sheet; figure below) and the macro in a new Excel file; when I try to execute the macro, this message appears:
...
0
votes
1
answer
762
views
Word macro: Insert text into each selected cell of a table
I am trying to format cells and insert text (in this case a checkbox) in each SELECTED cell in a table. This is used as a place keeping aid in my plant emergency procedures. The cells format properly, ...
0
votes
0
answers
67
views
Copy range of row using two dropdown list as start time and end time in Excel
I have list of data that fetched from SQL at defined time range:
At that image I also already make dropdown list named Start time and End time.
The question is: how can I make a macro that the output ...
0
votes
0
answers
20
views
Creating a formula on Excel for my table
I would like to create a formula that will auto update when more information is added to my table and when numbers change. I have created a table that shows how many licences I have and their annual ...
0
votes
1
answer
479
views
Designer button grayed out in macro-enabled presentation in PowerPoint. How to fix it?
I don't know if it's a bug or a “feature”, but if you're creating a macro-enabled presentation in PowerPoint the designer button is grayed-out.
As usual the Microsoft website is very “useful”. This is ...
0
votes
0
answers
26
views
How can I use a macro to create a new excel spreadsheet with values only and formatting (including results of conditional formatting)
I have written this macro to unprotect an existing worksheet, copy the data from the existing worksheet, open a new spreadsheet, paste the data to the new spreadsheet with values and formatting, then ...
0
votes
0
answers
19
views
How to change all caps text to normal case with the first word capitalized in sentences in PhraseExpress?
How do I get all caps to normal text? These are the codes that I've tried & how they've turned out. Some work & some don't. Also, I'm somewhat new to PhraseExpress so this is all a whole new ...
0
votes
1
answer
78
views
LibreOffice Impress macro is only half functional when used in presentation as opposed to outside
I made an .odp file that contains two slides.
In Slide 1, there is a single circle that when clicked on moves to Slide 2. This circle uses a simple interaction and no macro.
In Slide 2, there is a ...
0
votes
1
answer
137
views
Is it possible to restrict a VBA macro command to just one workbook?
I have macros added as commands to a specific workbook. But a new workbook will show the commands, and if I click it, it just opens the previous workbook. I would rather them not be there in new ...
0
votes
0
answers
91
views
How to write a macro that iterates an array of strings and displays one of them at any given time in LibreOffice Impress?
I teach Spelling at an elementary school. To make class more entertaining, I decided to add interactive content.
In this example, students are given a presentation. The picture in the slide is an ...
0
votes
1
answer
112
views
How to make an object permanently disappear after clicking on it once in Libreoffice Impress?
I am hosting a trivia night in my middle school next week. I plan to use LibreOffice Impress. In the first slide there are multiple topics to choose from. When I click on one, it moves to the slide ...
0
votes
3
answers
419
views
Replace leading apostrophe in excel
could anyone advise me about the following?
In excel sheet, all cells of column (F), contain something like that.
'10+5+3
I need to convert it to equation by replacing apostrophe with equal sign.
=10+...
0
votes
2
answers
33
views
Excel: is there a formula/code I can use to paste specific values based on a dropdown value?
I’m a new user looking for help on an Excel formula/macro code.
To demonstrate my scenario, let’s say I have a drop down list with values of “Breakfast, Lunch, and Dinner”. If the user selects ...