Why not have the load data button clear the sheets as the first act.

Otherwise use the Workbook_Open event

see Chip Pearson's page on event
http://www.cpearson.com/excel/events.htm

--
regards,
Tom Ogilvy

"Z" wrote in message
...
I have a "load data" button in the worksheet, so that when i open the
excel file i need all the previously entered data to be cleared from the
sheet, so that i can use the "load data" button to get that data on the
sheet. So my question is :"how do i make that data clear from the sheet when
i open the excel work book, so that i can use the load data button to get
that data on the sheet"