ClearContents

[Rauber]

Hi! How can I clear the contents of a worksheet at the moment I open the excel file? I want to clear the contents i had before opening the file. Thanks!

 

[chuckchuckit]

Welcome to the board!

If you have a Sub titled Autpen like shown below, it will automatically run as soon as you open the workbook.

Following code will clear everything in the shown range of worksheet name Sheet1. You of course can put any range or sheetname you wish there.

Sub Auto_Open()
    Sheets("Sheet1").Range("A1:Z25").Clear
End Sub

 

[chuckchuckit]

If you want that clearing to be done in the background so no one can see what was there, this added code should stop the screen from updating until the clearing is done. It should then just open with a blank screen even though you just cleared everything.

Sub Auto_Open()
 
    Application.ScreenUpdating = False 'turn off screen display
    Sheets("Sheet1").Range("A1:Z25").Clear
    Application.ScreenUpdating = True 'turn back on screen display changes
 
End Sub

 

[Rauber]

It worked perfectly! Thanks a lot!