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?

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