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

 

[Guest]

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