How to Review and Edit Macros in Excel

Stuck in a situation where you cannot edit a macro on a hidden workbook?

Looking for some quick fixes to easily overcome this cannot edit a macro in a hidden workbook upshot?

In that case, you are at the correct spot. As today in this post we will help you to know how you can become out of this problematic situation.

Besides this, you will also get to know the reason why you can't edit macro in personal workbook.

So without wasting whatsoever more time, let's directly dive into this post.

What Does "Cannot Edit Macros On A Hidden Workbook" Error Mean?

Here is the fault declaration: "Cannot edit macros on a hidden workbook. Unhide the workbook using the Unhide control."

Screenshot of this fault:

After the occurrence of this error you can't delete or edit macros on a subconscious workbook. So, equally to edit them you need to unhide it first.

Why You Cannot Edit A Macro On A Subconscious Workbook?

If you are wondering why all of a sudden the edit button in the macros dialog box grayed out. Then read out the following responsible causes behind this:

• Upgraded Excel application to latest version and thus few of its office doesn't support as per your PC's configuration.
• Excel workbook is somehow got corrupted.
• Add-ins added to the Excel file is obstructing you from editing its macro.
• Document is saved in xlsx format instead of xlsm.
• Your PC's security setting is hindering the running of your Excel macros.

How To Fix Cannot Edit A Macro On A Hidden Workbook Error?

Here are best possible fixes to troubleshoot Cannot edit macros on a subconscious workbook error are listed down.

ane# Unhide The Hidden Workbook

two# Disable The Add-Ins

3# Unhide The PERSONAL.Xlsb File

4# Save The Certificate In XLSM Format

5# Alter Trust Center Security Settings

6# Repair Corrupt Excel Workbook

So just go through them i by i…!

1# Unhide The Hidden Workbook

Note: you can't delete or edit macro from the Excel view in the hidden workbook.

Here are the steps that y'all demand to perform for editing macro in hidden workbook from the Excel view.

• At outset go to the Excel Ribbon.
• Afterwards that from the carte bar striking the View tab.
• Tap to the Windows Group so the hit the Unhide option.
• This will open a window in which you lot will see the entire list of hidden workbooks which are open.
• Now select the workbook which you want to unhide and hit the OK button.

If no countersign is applied on your Excel workbook, then it will get open unhidden immediately. Or else, you have to feed the password first.

Afterward this, when you lot try to edit the macro in a subconscious workbook and then it won't testify any error this time.

two# Disable The Add together-Ins

If add-ins are present in your excel file and then this tin likewise exist the reason backside inability to edit macro in a hidden workbook. So attempt to edit Excel macros afterward disabling them in one case and check whether you lot are getting the same error message this time.

Hither are the steps to disable add-ins in excel:

• Hit theFile> Options> Add together-ins.

• Now in theExcel choice window, select the COM Add-ins from your drib-down menu and hit theGetbutton.

• Unselect all the checkboxes and hit theOKbutton.

• Restart your Excel awarding and check whether the issue has been resolved or not.

3# Unhide The PERSONAL.Xlsb File

If macros which you are willing to delete is present within the PERSONAL.xlsb file and then firstly you need to unhide information technology.

Mostly it is seen that user fails to fetch and unhide this PERSONAL.xlsb file in Excel application. In that instance, you tin can expect for this file in the File Explorer.

Normally this file is institute in the following location:

C:\Users\ UserName\AppData\Roaming\Microsoft\Excel\PERSONAL

• Make a right click on the personal proper noun folder. Now from the menu choose the properties option.
• Only united nations-tick the subconscious property and tap to the OK button.
• Now cyberspace explorers brand confirmation whether you desire to apply your done changes to the sub files and folders or but to the folder.
• Brand selection as per your requirement and so hit the ok.

After this you will see that all the files within that specific folder are no more than hidden now. Besides that you can besides edit/delete macros present within them.

Helpful commodity: 5 Ways To Fix Personal Macro Workbook Not Opening Consequence

4# Save The Certificate In XLSM Format

If yous are frequently getting this cannot edit a macro on a subconscious workbook and then the very offset thing that yous need to figure out is the location where Excel macros are been saved.

If your macros are saved in the document and then ensure that yous salve it in xlsm file format. This is because if you save information technology in the xlsx file format and then macros will go removed of it.  Only if it is saved in the XLSM file format then you volition exist able to edit your macros anytime.

In instance, macros are not kept in the template instead of document section and then you have to load your template directly and then salve it back again past using macro-enabled template.

Afterward doing this, you tin easily modify your macros inside the template.

5# Modify Trust Eye Security Settings

Sometime your PC's security setting hinders you from editing the macros in hidden workbook. So this issue can hands be resolved from the trust center. Here are the steps that you demand to follow:

• Hit on theFile
• Tap to theOptions.
• Now hit on theTrust Centre, afterward then tap to theTrust Eye Settings.

• From theTrust Eye, tap to theMacro Settings.
• Hit the selection "Enable All Macros".
• Tap to the OK push.

This time when you open your Excel document, you tin can easily perform your macros editing.

Note: doing this will allow all the macros to run on your PC. So if you are pretty much sure that you won't open up any malicious code containing documents, so it's fine. Otherwise rerun the above step and choose the commencement selection i.eastward disable all macros with notifications.

This time when yous try to edit or delete your macro from workbook you volition not going to get any fault.

half dozen# Repair Decadent Excel Workbook

If none of the to a higher place solution worked in resolving this "cannot edit a macro on a hidden workbook. unhide the workbook using the unhide command". Then it's a clear sign that your Excel workbook is somehow got corrupted and so you need to repair information technology immediately. Subsequently then only you will be able to regain admission to your Excel macros.

Only to cutting downward your actress fourth dimension and endeavor of searching for such a reliable tool I accept a well-rounded solution i.eExcel Repair & Recovery tool. This software tool canrepair XLS/XLSX files in the most comprehensive mode.

• Very easily repair andrecover corrupt Excel files.
• Well compatible for both the Windows and Mac PC.
• Easy options to find and selectdamaged/corrupted Excel files.
• The software has the capability to fix any issue which is infecting your Excel file.
• Efficiently restorecorrupted Excel file past keeping the originality and properties completely intact.

* Complimentary version of the product only previews recoverable data.

Using theFree trial version ofExcel Repair & Recovery tool you can just see the preview of all your recoverable items. After the complete balls yous tin can buy this tool and relieve your repaired Excel files.

FAQ (Frequently Asked Question):

How Practice I Edit Macro Lawmaking Stored In My Personal Macro Workbook?

1st choice:

• follow this path Tools > Macro > Macros.
• From the opened dialog box, cull the macro that you wish to edit. After that hit the Edit choice.

2^nd pick:

• Go to the Visual Basic Editor. At present in the Projects window hitting the green color disclosure triangle for the Personal Macro Workbook.
• After that, check out the Modules binder and make double click over the Module.

How To Unhide A Workbook To Edit A Macro?

• Tap on the File tab, and so to the Options which is present at the bottom left bar.
• At present from the left side pane, choose Trust Eye, and striking the Trust Middle Settings… .
• From the opened dialog box of Trust Eye dialog box, hit the Macro Settings which is present on the left.
• Cull Enable all macros option and hitting OK push.

Wrap Up:

This is how you can easily fix cannot edit a macro on a subconscious workbook fault.

I promise you lot have found this tutorial helpful. If you are facing whatever other issue related to this specific ane then do let us know by sharing your feel on our social media FB andTwitter Page.

If you have something more than to share about this specific cannot edit a macro in a hidden workbook issue and so don't hesitate.

Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to empathize language is very impressive. When not writing, she loves unplanned travels.

murphyreackagots.blogspot.com

Source: https://www.repairmsexcel.com/blog/cannot-edit-macro-on-hidden-workbook