Sometimes when receiving a RAR document from others, we would be asked to type the corresponding password before extracting data from it. But what if you forget the password or just never knowing it. Don't worry, just use iSunshare RAR password genius to recover the password.
When you use Excel to edit some data, you may find that you need to remove some specified cell content in Excel workbook when opening or exiting it. Here i would show the way of clearing specified cell content when opening and exiting excel workbook.Please do as follow.
Step 1: Open the Excel and follow the chain File > Save As > Browse to navigate to Browse option and click this option to find a folder to store the changed Excel workbook.
Step 2: When the Save As dialog pop up, you should select a folder to save the workbook and give a name to it. Don't forget choose the type of file to be Excel Macro-Enabled Workbook in the Save as type box. Last, don't forget click Save button.
Step 3: When the Microsoft Excel window pop up, you should click OK after carefully checking the information.
Step 4: Press Alt+F11 to open the Microsoft Visual Basic for Applications window. Select the target workbook you want in the left pane of the window and click Insert>>Module to bring up a module section.
Step 5: When you need to clear some specified cell content When opening Excel workbook, you should type the under codes in the module section. PrivateSub Workbook_Open() Application.EnableEvents = False Worksheets("iSunshare").Range("A1:A11").Clear Application.EnableEvents = True End Sub
Attentions: In the above codes, iSunshare and A1:A11 is the worksheet name and cell range you will clear contents from. Please adapt them for your condition.
Step 6: Press run icon orjust navigate to Run>>Run Macro F5 to execute the codes and some specified cell content would be cleared. What's more, if you want to remove the specified cell content when exiting the Excel workbook, just paste the under codes in module section and execute it.PrivateSub Workbook_BeforeClose(Cancel As Boolean) Worksheets("test").Range("A1:A11").Clear End Sub
Step 7: Press Alt+Q key to close the Microsoft Visual Basic for Applications window. From now on, when opening or closing the workbook, specified cell contents in certain worksheet will be cleared.