Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet name
Appreciate any help / advice.
We have a worksheet created in Excel (Office 97) that is used for a type of stock control. Each sheet refers to a week and at the end of the week, a sheet is created by copying the last sheet. We've found that this now causes Excel to crash when we try to save. I've looked in the "Visual Basic Editor" (under "Tools", "Macro") and found that the sheets are being given a name such as Sheet2111(week4) and then each new sheet the number increases by an additional digit (eg. the next sheets would be Sheet21111(week5) and Sheet211111 (week6). (Currently up to Week28!) Is it possible to modify these names in the VBA editor to stop the crashing? Many thanks in advance for any assistance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet name
Hi Tony,
This is a known bug in xl97. To change the sheet name, in the VBE select the offending sheet; your F4 function key will open the Properties window and you can replace the first property (Name) with a shorter unique alternative. To prevent repetition of the problem, avoid copying the copy of the copy, but instead copy the same sheet each week. --- Regards, Norman "Tony S" wrote in message ... Appreciate any help / advice. We have a worksheet created in Excel (Office 97) that is used for a type of stock control. Each sheet refers to a week and at the end of the week, a sheet is created by copying the last sheet. We've found that this now causes Excel to crash when we try to save. I've looked in the "Visual Basic Editor" (under "Tools", "Macro") and found that the sheets are being given a name such as Sheet2111(week4) and then each new sheet the number increases by an additional digit (eg. the next sheets would be Sheet21111(week5) and Sheet211111 (week6). (Currently up to Week28!) Is it possible to modify these names in the VBA editor to stop the crashing? Many thanks in advance for any assistance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet name
Just to add, copying the same sheet will delay the onset of the problem. It
will not necessarily prevent it, but the 52 copies shouldn't be a problem depending on the name of the single sheet. -- Regards, Tom Ogilvy "Norman Jones" wrote in message ... Hi Tony, This is a known bug in xl97. To change the sheet name, in the VBE select the offending sheet; your F4 function key will open the Properties window and you can replace the first property (Name) with a shorter unique alternative. To prevent repetition of the problem, avoid copying the copy of the copy, but instead copy the same sheet each week. --- Regards, Norman "Tony S" wrote in message ... Appreciate any help / advice. We have a worksheet created in Excel (Office 97) that is used for a type of stock control. Each sheet refers to a week and at the end of the week, a sheet is created by copying the last sheet. We've found that this now causes Excel to crash when we try to save. I've looked in the "Visual Basic Editor" (under "Tools", "Macro") and found that the sheets are being given a name such as Sheet2111(week4) and then each new sheet the number increases by an additional digit (eg. the next sheets would be Sheet21111(week5) and Sheet211111 (week6). (Currently up to Week28!) Is it possible to modify these names in the VBA editor to stop the crashing? Many thanks in advance for any assistance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet name
Norman,
many thanks, that's exactly what I needed. I've checked and it works as per your instructions. Also appreciate the input from Tom. Regards Tony -----Original Message----- Hi Tony, This is a known bug in xl97. To change the sheet name, in the VBE select the offending sheet; your F4 function key will open the Properties window and you can replace the first property (Name) with a shorter unique alternative. To prevent repetition of the problem, avoid copying the copy of the copy, but instead copy the same sheet each week. --- Regards, Norman "Tony S" wrote in message ... Appreciate any help / advice. We have a worksheet created in Excel (Office 97) that is used for a type of stock control. Each sheet refers to a week and at the end of the week, a sheet is created by copying the last sheet. We've found that this now causes Excel to crash when we try to save. I've looked in the "Visual Basic Editor" (under "Tools", "Macro") and found that the sheets are being given a name such as Sheet2111(week4) and then each new sheet the number increases by an additional digit (eg. the next sheets would be Sheet21111(week5) and Sheet211111 (week6). (Currently up to Week28!) Is it possible to modify these names in the VBA editor to stop the crashing? Many thanks in advance for any assistance . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |