Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to clean a worksheet
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to clean a worksheet
Deleting and adding sounds like a much nicer way to me.
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to clean a worksheet
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to clean a worksheet
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to clean a worksheet
It is true that a protected workbook restricts an unauthorized user from
doing certain things. However, since you had implied that you had access to the workbook, it was assumed that you would be able to handle the protection part. So, if you are an authorized user and you want a clean sheet, then deleting the old one and replacing it with a new one will guarantee that there are no hidden formulas, cells, rows, columns, controls or code to worry about. "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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to clean a worksheet
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to clean a worksheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro using CLEAN & PROPER on a worksheet. | Excel Discussion (Misc queries) | |||
CLEAN on whole Worksheet | Excel Discussion (Misc queries) | |||
Clean up help | Excel Programming | |||
Help me clean this up... | Excel Programming | |||
=clean(a1) | Excel Programming |