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

Fiverr Microsoft Excel 2016 Skill Test and Answers 2021

This video will help you about preparing Fiverr Excel Skill Test. I've just taken this Fiverr Excel Skill Test and successfully passed with a scored 6 out of 10. I'm sharing my Fiverr Excel Skill Test and Answers 2021 video so that you can prepare yourself if you would like to give a test on Fiverr.    I have taken the Fiverr Excel Skill Test on Fiverr and obtained 6 out of 10 scores. If you take a test and pass, it will greatly help the buyer to trust you and your skills. Please note that your exam will not be exactly the same as mine because there are many more questions in the pool than 40 which appeared in my test. But I am hopeful that you will succeed in it. If you have any queries, please write them in the comment section. I will try my best to guide you.Follow this video and try to get a general idea. By following the instructions, you can successfully pass the test.    After passing the Fiverr Excel Skill Test, Fiverr shared a Excel Expert Badge on my Profile, so that
2 comments
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