| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error 1004 naming a sheet
Using Excel 97 on Windows 2000 Pro., the following code runs fine:
sheets(1).name = "Data" However, when run on a client's machine using Excel 2000 and XP, this causes the run time error. Anyone have any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
run time error 1004 naming a sheet
Do you have another sheet that already has the name "Data"?
Is the workbook protected (tools|protection|protect workbook)? Robert wrote: Using Excel 97 on Windows 2000 Pro., the following code runs fine: sheets(1).name = "Data" However, when run on a client's machine using Excel 2000 and XP, this causes the run time error. Anyone have any ideas? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run time error 1004 | Excel Discussion (Misc queries) | |||
| run time error 1004 | Excel Discussion (Misc queries) | |||
| Run time error 1004, General ODBC error | New Users to Excel | |||
| Run-time error 1004 and SR-1 | Excel Programming | |||
| Run-time error 1004 | Excel Programming | |||
Linear Mode
