Skip to main content

New Article

How to SUM by matching partial text in Excel

Post a Comment

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.

Image 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 Microsoft Excel.

Re-Open the workbook which contains the macro. This will refresh the Excel Program to help loading the Personal Macro in Macro list.

Go to Developer tab and Click on Macro to open the Macro dialog box.

Image 4: Macro tool

This dialog box will show the macro list. By default it will show the Public Macro list. Select PERSONAL.XLSB from Macros in drop down list.

Image 5: Selecting Personal.xlsb from Macro dialog box

Now this will show the Personal macro list.

Image 6: Personal macro list

Select the Macro name which you want to delete from Macro Name and Click on Delete button. For confirmation a message will appear.

Image 7: Personal macro deleting confirmation message box

Click on Yes button to delete the macro under Personal.xlsb file. Save the Workbook that. Close and Exit the Excel program.


How to delete from Hard Drive?

Macro has deleted. But, it may disturb you while you open any MS Excel file next time. To solve this you can delete it physically from Hard Drive. So, how to do it?

Go to any Windows Folder and Click on Options from View menu. To display the Folder Options dialog box.

Image 8: Folder option

This will show a Folder Options dialog box. Click on View tab and make sure that the Show hidden files, folders, and drives option has checked.

Image 9: Showing hidden files in Windows Folder

Go to this location: C:\Users\faysal\AppData\Roaming\Microsoft\Excel\XLSTART and DELETE the Personal.xlsb file and Empty from recycle bin of your PC.

Image 10: Delete the Personal.xlsb file located in XLSTART folder

This will help you to escape the personal.xlsb (personal macro) display problem in Excel VBA.
Labels:

Popular posts from this blog

How to display an image in worksheet based on a List or based on IF condition?

Excel can show image on worksheet based on a specific IF condition. So, how to do it? Simple follow the below steps: Step by Step: Step 1: Insert images in your Excel Worksheet. Here I've inserted 5 different types of balls, Football, Cricket, Pool, Basketball, Tennis ball. Note that, All balls are placed into different cell. These are placed in Picture sheet. Image 1: 5 balls placed in 5 different cells and covered photo's wide and height Step 2: In the report sheet, design the report as you wish. I've designed in my way like below: Image 2: Kids asking to Donald Duck, which ball need to throw now Step 3: Make a drop down list "Games" in E6 cell in Report sheet from Data Validation. which is as below: Football Cricket Pool Basketball Tennis You can do an IF function here in E6 in Report sheet, which will meet a certain condition and returned Football, Cricket, Pool, Basketball or Tennis. Step 4: Now the tricky part is...
Read more

Cumulative Closing Balance like a Bank Statement in PivotTable

A Bank Employee in many case needs to calculate the Closing Balance after each transaction in PivotTable like a Bank Statement . But with the help of Calculated Field of a PivotTable , you can only calculate Field with Field . It's not possible to use a formula in Calculated Field where you can mention a single cell with Relative Reference Cell . Because a PivotTable acts like a Table format where you can work with Field or Column Name . A Helping Column (A regular column, that helps to get a partial result where formula applied) can be a good idea. But there is an option in PivotTable by which you can Calculate Cumulative . In this article I will show you, how you can do it. Calculating with Formula: Assume that, you have an Excel file with Debit and Credit transaction of an Account . Image 1: Sample Bank Statement In a Bank Statement , Month wise Cumulative Balance is important. In the Excel sheet, as above, it is very easy to use a formula and calc...
Read more

Value Paste and Formula Paste

In many case, in our professional life, we need to do Copy and Value Paste or Copy and Formula Paste in all most always. Those employees, who works under MIS Department, have to do it lots of time in a single day to prepare reports. It is very time costing task in Office. Many of us use Excel Menubar to do it, others are using Keyboard Shortcut by pressing ALT key (like for Value Paste Press ALT+H+V+V and for Formula Paste Press ALT+H+V+F ). But did you noticed that, these two ways strongly need your attention to do this task. More clearly, if you choose Value Paste from Menubar , then what you need to do? First you should take the mouse in Hand Wheel the mouse in Home menu Then Click on Paste Then you pressure your eyes to find the Value Paste icon And then Click on it to paste it These all steps can take more than 1 second. Am I right? Below is an image of this process: Image 1: Value Paste from Home Menu On the other hand, if you choose the shortcut f...
Read more