PDA

View Full Version : Solved: Help in tabbing



Ashes.cfg
11-01-2007, 07:49 AM
hey guys
I have a doubt regarding a command.. what the command in vba if i want to have a tab with a personalized name and the remaining sheets shudnt be there..like for eg..see the attached.. i dont want sheet 2 and sheet 3 to be there..the only worksheet which should be there is Assigned. I would have one more problem for you guys..but i will post it once i try to solve it on my own and finally give up lol...

pl let me know..

Thanks
Ashes.cfg

Bob Phillips
11-01-2007, 08:42 AM
Application.DisplayALerts = false
For Each sh In Activeworkbook.Worksheets
If sh.Name <> "Assigned" Then
sh.Delete
End If
Next sh
Application.DisplayAlerts = True

Ashes.cfg
11-01-2007, 08:50 AM
K thanks prob solved simple as ever :)