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 |
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 |