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 |
#2
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. If you have many sheets connected with each other , especially when u use formulas such "lookup", "sum.if" etc. it might happend that after every change of name of a sheet everything is recalculating. Try to change option ( tools, options...) "recalculate automatically" into "recalculate manually" then we'll see if any difference appear. do not forget that if workbook is recalculated manually the results of any formula is unchanged until u run "recalculate" (F9) option or before saving of file. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
naming sheets
Hi Christian,
Here is one way Private iSheet As Long Private Sub Workbook_NewSheet(ByVal Sh As Object) iSheet = Worksheets.Count Sh.Name = "Tabelle" & iSheet End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob Phillips "Christian Galbavy" wrote in message ... 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 |
Reply |
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 |