Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
naming sheets
Hello!
I think there is a general problem with excel. When I have several sheets (over 20), and I want to rename a sheet, this takes about 30 seconds. I do not know why and what is happening in the background, but it is a big problem for my program. I use the "add" function to insert new sheets, and the I use the "sheet.name" function to rename the inserted sheets. I have more than 40 sheets in my workbook and as I said, the renaming-process takes up to a minute. When I insert a new sheet, my german excel version automatically names the sheets like "Tabelle1", "Tabelle2", ... Is there a function to set a certain name here, befor the insertion happens? Or does anybody know, why the renaming function takes so much time? Thanks for your help. Regards Christian Galbavy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming sheets from a cell value | Excel Discussion (Misc queries) | |||
VBA Help naming sheets | Excel Discussion (Misc queries) | |||
Naming Sheets for day of the month | Excel Discussion (Misc queries) | |||
Naming Sheets Tabs | Excel Worksheet Functions | |||
Inserting Sheets and Naming | Excel Programming |