Create a new Worksheet

[Syed Haider Ali]

Dear Friends.

How we can create a new temporary worksheet having name "Temp". And when we close our userform it is deleted automatically.

Thanks

Syed Haider Ali

[K Dales]

You should be able to incorporate the commands into existing code.

In the code that shows your userform:
Dim TempWS as Worksheet
Set TempWS = ThisWorkbook.Worksheets.Add
TempWs.Name = "Temp"
.... ' Rest of the code that shows the UserForm


Then, when you hide the userform:
TempWS.Delete
.... 'Rest of the code that hides the userform
--
- K Dales


"Syed Haider Ali" wrote:

>
> Dear Friends.
>
> How we can create a new temporary worksheet having name "Temp". And
> when we close our userform it is deleted automatically.
>
> Thanks
>
> Syed Haider Ali
>
>
> --
> Syed Haider Ali
> ------------------------------------------------------------------------
> Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994
> View this thread: http://www.excelforum.com/showthread...hreadid=490258
>
>