Delete all blank worksheet using Personal Macro
In this article, we have create the a Personal Macro to delete all blank worksheet from active workbook. You can use this for the workbook wherein you have multiple worksheet
Tag: Personal workbook
Create Multiple Names Using VBA in Excel with One Click
Need to create multiple names using VBA in Excel instead of adding them one by one in Name Manager? In this tutorial you build a small macro that turns every
Personal Macro in Excel: Quick Data Formatting with Ctrl+M
A personal macro in Excel is a macro saved in your hidden Personal Macro Workbook (PERSONAL.XLSB), so it is ready in every workbook you open on that computer. In this