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.