Delete Range on save/open

[David0079]

Hey Everyone, I have a range of cells which I would like to be blank when a workbok is opened. I currently have some code in 'thisworkbook' which blanks them but you still see them as the sheet is activated. How can I make sure you can't see them when its opened? Is there a way to blank them on Save?
Thanks all, Dave

 

[ADAMC]

When you say blank them do you mean delete them?

Instead of using Workbook open, use workbook before save event:
something like:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("A1:A10").Delete
End Sub