run time error 1004 naming a sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Do you have another sheet that already has the name "Data"?

Is the workbook protected (tools|protection|protect workbook)?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Run-time error '1004' General ODBC Error 1
Run-time-error 1004 "ListIndex method of listbox class failed" 1
Run-time error 1004 3
"Run-time error '1004' 5
Run-time Error '1004': Selection is too large. 0
Runtime error 1004: Select method of worksheet class failed 3
Error '1004' 4
Run Time Error '1004' General ODBC Error 7

Back
Top