| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I insert the file name as my Worksheet name in the tab?
I was wondering how do I automatically instert my file name as my tab name
instead of "Sheet 1" without having to right click and select "rename" and typing the file name into the tab? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I insert the file name as my Worksheet name in the tab?
Try this tiny macro:
Sub hdksa() ActiveSheet.Name = ActiveSheet.Parent.Name End Sub -- Gary''s Student - gsnu200790 "Dennis" wrote: I was wondering how do I automatically instert my file name as my tab name instead of "Sheet 1" without having to right click and select "rename" and typing the file name into the tab? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't insert a worksheet into my current spreadsheet file | Excel Worksheet Functions | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| Wish to add a WORKSHEET but 'WORKSHEET' not open in 'INSERT' | Excel Worksheet Functions | |||
| Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
| How can I insert a picture from file while worksheet is protected | Excel Discussion (Misc queries) | |||
Hybrid Mode
