- Enable personal macro workbook excel 2016 how to#
- Enable personal macro workbook excel 2016 windows#
This will open a window in which you will see the entire list of hidden workbooks which are open.
Enable personal macro workbook excel 2016 windows#
Tap to the Windows Group and then the hit the Unhide option. After that from the menu bar hit the View tab. Here are the steps that you need to perform for editing macro in hidden workbook from the Excel view. Note: you can’t delete or edit macro from the Excel view in the hidden workbook. 
Here are best possible fixes to troubleshoot Cannot edit macros on a hidden workbook error are listed down.
Enable personal macro workbook excel 2016 how to#
How To Fix Cannot Edit A Macro On A Hidden Workbook Error?
Your PC’s security setting is hindering the running of your Excel macros. Document is saved in xlsx format instead of xlsm. Add-ins added to the Excel file is obstructing you from editing its macro. Excel workbook is somehow got corrupted. Upgraded Excel application to latest version and thus few of its function doesn’t support as per your PC’s configuration. Then read out the following responsible causes behind this: If you are wondering why all of a sudden the edit button in the macros dialog box grayed out. Why You Cannot Edit A Macro On A Hidden Workbook? So, as to edit them you need to unhide it first. Unhide the workbook using the Unhide command.”Īfter the occurrence of this error you can’t delete or edit macros on a hidden workbook. Here is the error declaration: “Cannot edit macros on a hidden workbook. What Does “Cannot Edit Macros On A Hidden Workbook” Error Mean? So without wasting any more time, let’s directly dive into this post.
0 kommentar(er)
