Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a code that anables you tto search for a worksheet
Is there a code that anables you to search for a worksheet by reference to
the Tabs, and if it exsists display the sheet or if it does not exsists create a new worksheet from a template (say sheet1)? -- AOU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a code that anables you tto search for a worksheet
Sub makesheetorgoto()
On Error GoTo makeit Sheets("joe").Select Exit Sub makeit: Sheets.Add.Name = "joe" End Sub -- Don Guillett SalesAid Software "AOU" wrote in message ... Is there a code that anables you to search for a worksheet by reference to the Tabs, and if it exsists display the sheet or if it does not exsists create a new worksheet from a template (say sheet1)? -- AOU |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a code that anables you tto search for a worksheet
Thanks very much Don, very useful. Can you tell me the code if I wanted to
use a Userform for the following: On a click og a commandbuttton a userform appears and asks to insert name of person to check. If this person has a sheet then it goes to it, if there is no sheet a messagebox asks if you want to create a new sheet for the person. If yes then copies from a template (sheet1) and open it. Would very much appreciate help on this. Thank you -- AOU "Don Guillett" wrote: Sub makesheetorgoto() On Error GoTo makeit Sheets("joe").Select Exit Sub makeit: Sheets.Add.Name = "joe" End Sub -- Don Guillett SalesAid Software "AOU" wrote in message ... Is there a code that anables you to search for a worksheet by reference to the Tabs, and if it exsists display the sheet or if it does not exsists create a new worksheet from a template (say sheet1)? -- AOU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Questions | New Users to Excel | |||
Starting/Stopping Worksheet Event Code | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
better search: "make worksheet visible" | Excel Discussion (Misc queries) |