How about saving the "clean" workbook as a template and using the template to
start each new session.

"Dave Peterson" wrote:

And you may be dealing with a worksheet that's protected. What would you do
then?



guest wrote:

I agree deleting and adding is much better way but we might be dealing with
protected workbook. which prevents us from adding, deleting or moving
worksheets.

"JLGWhiz" wrote:

Delete and add leaves no doubt.

"guest" wrote:

I have a worksheet with data and active x controls like textbox, checkbox
etc. I need to clean the worksheet or it should look like a brand new
worksheet in every session.. is there any better way to do that, right now I
am deleting it and creating a new worksheet with the same name.

--

Dave Peterson