How do i unhide personal xlsb

If the file is not protected with a password, it will get unhidden immediately. Otherwise you will need to enter the password. Now if you try to delete the macro, it will show no error. Well this happens when you have add-ins added to the file.

The add-in file can be hidden but when you open Excel it opens with it to provide its features. If you try to edit or delete macros from these files, you will get the same error message. If you think you don't have any add-ins, you are right to think so. This file opens up every time you open Excel.

If you are unable to unhide the file from Excel. Then you can locate the file in File Explorer. This file is usually stored at this generic location. Right Click on the folder. Go to properties. Here, uncheck the hidden property and hit OK. Now explorer will ask if you want to make changes to sub folders and files or only to this folder. Check out the second one. Click on the OK button. To check if the file has been created, open a blank workbook and select the View tab. If the Unhide command is disabled, then your Personal.

If the Unhide command is enabled, press it and see if the Personal. If this filename appears in the list then the file exists. This file is saved in your Excel startup folder when you close Excel. If you have a Personal. When you record your first macro it will default to being saved in "This Workbook". This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

I have the same question Report abuse. Details required :. Cancel Submit. Tom Ogilvy MVP. Enter your address and click "Subscribe. Your e-mail address is not shared with anyone, ever. Maximum image size is 6Mpixels. Images larger than px wide or px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. That doesn't work for office I still get the blank page even though it states that the personal file is hidden.

XLSB file after placing a macro in it. My issue is resolved. I found the problem and fixed it. The xlsb file itself was hidden. When I unhid that file and then changed the view of the opened Personal. I am running Excel in Win 8. I have personal. I have started Excel and set this setting and clicked OK and closed Excel, then re-start Excel and there is no entry retained.

Personal is there but will not open. It is not listed when I open VBE and look. I have an addin that loads from elsewhere, and it is listed, but not personal.

Please help!