How to Fix the Unable to Record Macro Error in Excel 2019?
![](/images/site-logo.png)
How to Fix the Unable to Record Macro Error in Excel?
Summary: You may encounter the “Unable to record macro” error in MS Excel when using Personal Macro Workbooks. In this post, we’ll discuss the possible causes behind this error and the ways to fix it. We’ll also mention a professional Excel repair tool that can help fix the error if it occurs due to corrupted workbook.
A personal macro workbook (Personal.xlsb file) is a hidden workbook in Excel that stores all macros in a single workbook. This allows you to automate processes while working in Excel. Sometimes, when recording macro codes in the personal macro workbook, you may get the message “Personal Macro Workbook in a startup folder must stay open for recording”. When you click on the OK button, it will show the “unable to record” error. This prevents you from recording the macros. Below, we’ll see the causes behind this error and discuss how to resolve this error.
Causes of Unable to Record Macro Error
You may be unable to record macros in Excel due to several reasons. Let’s take a look at the possible causes that can lead to this issue.
- The location of personal.xlsb file is changed.
- Personal.xlsb file is corrupted.
- Macros are disabled.
Methods to Fix the “Unable to Record Macro” Error in Excel
Here are some possible solutions that can help you resolve the unable to record macro error in Excel.
Method 1: Check the Path of XLStart Folder
You may be unable to record macros if the path of XLStart folder is incorrect. It is a folder where the Personal.xlsb file is stored by default. Follow these steps to find out the path of this folder:
- Open MS Excel. Go to File > Options.
- Click Trust Center > Trust Center Settings.
- In the Trust Center Settings window, click on Trusted Locations.
- Verify the path of the XLSTART folder and modify it if there is an issue.
- Once you are done, click on OK.
Method 2: Change Macro Security
The “Unable to record macro” error can occur if macros are disabled in the Macro Security settings. You can try changing the macro settings using the below steps:
- In MS Excel, go to File > Options > Trust Center.
- Under Trust Center, click on Trust Center Settings.
- Select “Enable all macros” and then click OK.
Method 3: Check Add-ins for Disabled Items
If there are any items in add-ins that are disabled, they may prevent Excel from functioning properly. You can check and enable the items in MS Excel using the below steps:
- Click File > Options.
- In Excel Options, click on the Add-ins option.
- Select Disabled Items from the Manage section and click on Go.
- The Disabled Items window is displayed.
- Click on the disabled item and then click Enable.
- Restart Excel for the changes to take place.
Method 4: Repair your Excel File
You may fail to record macros if there is corruption in the workbook. In such a case, you can use the “Open and Repair” utility in MS Excel to repair the corrupt workbook. To use this tool, follow these steps:
- Open your Excel application.
- Click File > Open.
- Browse to the location where the corrupted file is stored.
- In the Open dialog box, choose the corrupted workbook.
- From the Open dropdown list, click Open and Repair.
Excel will prompt you to repair the file or extract data from it. Click Repair to retrieve maximum data. If the Repair option fails, then click on the Extract Data option to recover the data without formulas and values.
If the Microsoft utility “Open and Repair” fails to repair the corrupted Excel workbook, then try a professional Excel repair tool such as Stellar Repair for Excel. It is an advanced tool that can easily repair severely corrupted Excel (XLSX and XLS) files. It can recover all the file items, including chart sheets, cell comments, tables, macros, formulas, etc. without impacting the properties and cell format of the Excel file.
Closure
You may receive the “unable to record” error in Excel while creating or storing macros in Personal Macro Workbooks. There are several reasons that can lead to this error. You can try the methods covered in this post to resolve the error. If the error appears due to corruption in workbook, then try to repair it using the Open and Repair utility. Alternatively, you can use Stellar Repair for Excel – a professional tool that can help you repair an Excel file with problematic macros. Also, it allows recovery of all the file components with complete integrity. The tool is compatible with Excel 2021, 2019, 2016, and older versions.
Also read:
- How to retrieve erased call logs from Vivo Y27s?
- How to Repair Broken video files of Vivo Y100 5G?
- 4 Ways to Transfer Music from Samsung Galaxy XCover 6 Pro Tactical Edition to iPhone | Dr.fone
- How To Restore Missing Contacts Files from Vivo S17e.
- How to Retrieve deleted photos on Nubia
- How to Recover Deleted iPhone 12 Pro Camera Roll Photos and Photo Stream Pictures? | Stellar
- How to recover old music from your Oppo Find X6
- How to Recover iPhone 15 Plus Data From iOS iTunes? | Dr.fone
- How to Retrieve deleted photos on Oppo Reno 11 5G
- How to Downgrade iPhone SE without Losing Data? | Dr.fone
- How to install and update device drivers manually on Windows 7
- How To Transfer Data From iPhone 11 To Android/iOS? | Dr.fone
- How to Resolve Format error not a PDF or corrupted Error of PDF File | Stellar
- How to recover lost data from Nokia C12?
- How To Restore Missing Messages Files from Realme 10T 5G
- How to Nokia C12 Get Deleted Phone Number Back with Ease and Safety
- How to get back lost contacts from Sony Xperia 1 V.
- How to recover deleted photos from Android Gallery after format on Edge+ (2023)
- How to recover old messages from your 12 Pro 5G
- How to Downgrade iPhone 12 without Losing Any Content? | Dr.fone
- How to recover data from dead iPhone 12 mini | Stellar
- How to Rescue Lost Photos from Motorola Edge 40 Neo?
- How to recover deleted photos from Google Pixel 8.
- How To Restore Missing Photos Files from Motorola Moto G04.
- How to Electronically Sign a .docx file Using DigiSigner
- How to Remove iPhone 15 Pro Max Face ID?
- How To Restore Missing Contacts Files from Google Pixel 8.
- How to Fix Excel Formulas Not Working Properly | Step-by-Step Guide
- How to sign Word 2023 free
- How to recover old call logs from your ZTE Nubia Z60 Ultra?
- How to Rescue Lost Music from Realme 11 Pro
- How to Repair Broken video files of Moto G 5G (2023) on Mac?
- How to retrieve erased messages from Realme 11 5G
- How to get back lost photos from Honor .
- How to recover deleted contacts from Y36.
- How to insert signature in Excel 2003 files
- How to Repair Broken video files of Xiaomi Civi 3 on Windows??
- How to get back lost photos from Vivo V29 Pro.
- How to Recover iPhone 14 Pro Max Data From iOS iTunes Backup? | Dr.fone
- 6 Ways to Change Spotify Location On Your Motorola Moto G04 | Dr.fone
- Updated Compressor in FCPX A Beginners Guide to Efficient Video Encoding
- In 2024, How To Use Allshare Cast To Turn On Screen Mirroring On Nubia Red Magic 8S Pro+ | Dr.fone
- Pokémon Go Cooldown Chart On Samsung Galaxy A14 5G | Dr.fone
- In 2024, Best 3 Software to Transfer Files to/from Your Honor Magic 6 via a USB Cable | Dr.fone
- Where Is the Best Place to Catch Dratini On OnePlus Nord N30 5G | Dr.fone
- Updated In 2024, Some Techniques for Creating Animated Logo That Few People Know About
- In 2024, Unlock Your Realme 12 Pro 5G Phone with Ease The 3 Best Lock Screen Removal Tools
- Update your drivers with Device Manager in Windows 11/10/7
- In 2024, Is Fake GPS Location Spoofer a Good Choice On Lava Yuva 2? | Dr.fone
- Tips and Tricks for Apple ID Locked Issue From Apple iPhone 11 Pro Max
- In 2024, 8 Best Apps for Screen Mirroring Samsung Galaxy A24 PC | Dr.fone
- 5 Easy Ways to Change Location on YouTube TV On Realme 11 5G | Dr.fone
- Complete Tutorial for Poco X6 Pro Hard Reset | Dr.fone
- Bypassing Google Account With vnROM Bypass For ZTE Nubia Z60 Ultra
- How to Change Google Play Location On Xiaomi Redmi Note 12T Pro | Dr.fone
- updated In 2024, The Ever-Changing Era of AI Video Translation A Reality to Be Fulfilled
- Ultimate Aiff Converter Selection Blueprint for 2024
- Prank Your Friends! Easy Ways to Fake and Share Google Maps Location On Poco C65 | Dr.fone
- How to Share/Fake Location on WhatsApp for Apple iPhone 14 Pro | Dr.fone
- Top 5 Car Locator Apps for Xiaomi Redmi Note 12T Pro | Dr.fone
- New 2024 Approved Hard to Remove Black Background in After Effects? Heres the Best Way to Deal With It
- In 2024, Full Guide to Bypass Samsung Galaxy A54 5G FRP
- In 2024, Three Ways to Sim Unlock Vivo Y27s
- The way to get back lost music from Tecno Spark 20C
- 3 Solutions to Find Your Samsung Galaxy Z Fold 5 Current Location of a Mobile Number | Dr.fone
- Title: How to Fix the Unable to Record Macro Error in Excel 2019?
- Author: Nova
- Created at : 2024-05-19 18:32:11
- Updated at : 2024-05-21 02:34:23
- Link: https://blog-min.techidaily.com/how-to-fix-the-unable-to-record-macro-error-in-excel-2019-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.