Make selection as per your requirement and then hit the ok.Īfter this you will see that all the files within that specific folder are no more hidden now.Now internet explorers make confirmation whether you want to apply your done changes to the sub files and folders or only to the folder.Just un-tick the hidden property and tap to the OK button.Now from the menu choose the properties option. Make a right click on the personal name folder.Usually this file is found in the following location:Ĭ:\Users\ UserName\AppData\Roaming\Microsoft\Excel\PERSONAL In that case, you can look for this file in the File Explorer. Mostly it is seen that user fails to fetch and unhide this PERSONAL.xlsb file in Excel application. If macros which you are willing to delete is present within the PERSONAL.xlsb file then firstly you need to unhide it. Restart your Excel application and check whether the issue has been resolved or not.Unselect all the checkboxes and hit the OK button.Now in the Excel option window, select the COM Add-ins from your drop-down menu and hit the Go button.Here are the steps to disable add-ins in excel: So try to edit Excel macros after disabling them once and check whether you are getting the same error message this time. If add-ins are present in your excel file then this can also be the reason behind inability to edit macro in a hidden workbook. Or else, you have to feed the password first.Īfter this, when you try to edit the macro in a hidden workbook then it won’t show any error this time. If no password is applied on your Excel workbook, then it will get open unhidden immediately. Now select the workbook which you want to unhide and hit the OK button.This will open a window in which you will see the entire list of hidden workbooks which are open.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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |