Excel File Recovery

How to Enable and Disable Macros in Your Excel

The security of macro is a key element for the security of Excel. Therefore, today we will talk about how to enable/disable macros in your Excel. Macro is very effective in dealing with complex tasks. However, there will also be dangers in some macro-enabled workbooks. If you run those macros unintentionally, your Excel could be damaged. Hence, correctly enabling/disabling macros macro is rather important. Open the Macro Settings Dialog Before you modify the settings, you need to open the...

Read more »

How to Password Protect VBA Codes in Your Excel Worksheet

Except for setting passwords for your Excel files and worksheets, now you can also password protect VBA codes. In this article, we will show you the method to fulfill this task. VBA codes in a macro-enabled workbook are certainly very essential to your work. Hence, you need to protect those codes. Among all the protection methods, you can set passwords for the codes. And below are the steps about this task. Protect VBA Codes Open the target file that contains the VBA codes that you...

Read more »

4 Effective Methods to Insert Multiple Rows or Columns into Your Worksheet

Inserting rows or columns into a worksheet is a very easy process. But sometimes you need to insert multiple rows or columns into a worksheet. You can use the 4 methods in this article. Due to the need of a task, you will need to insert multiple rows or columns into a worksheet. The image below shows a list of product names. And now you need to insert 5 rows after row 8. And you can follow the steps below to learn those different methods. Method 1: Insert Manually This is the most...

Read more »