Skip to main content

Posts

Showing posts from June, 2016

New Article

How to SUM by matching partial text in Excel

How to delete Personal.xlsb file that contains personal macro?

Personal Macro is restricted to use with others opened Excel workbook. So, it hides by default from Macro list. Personal Macro basically creates another Excel window which is hidden. If you unhide the hidden window then you can see the Personal Macro. Before you Delete the Personal Macro, you need to unhide the Excel window first. How to unhide the Personal Macro Window? To Open the Personal Macro Window first go to the Workbook that contains the Personal Macro. Then Click on View | Unhide: Image 1: Unhide the Personal Macro Workbook Then you will see a Unhide dialog box contains the unhide workbooks list: Image 2: Unhide workbook Click on PERSONAL and then Ok. Now you will see that new Personal Workbook displayed and shown in Taskbar. I mage 3: After unhide the Personal workbook shown in Taskbar How to delete from Personal Macro? After unhiding the Personal workbook, Close all opened workbook including Personal Workbook that contains personal macro. And Exit from Microso...