| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Activate method of Worksheet class fails in Excel 2000
I'm having trouble getting a distributed macro to work on a few
machines. The macro fails on the first line which reads: Worksheet(1).Activate I've also tried using the Sheets collection, but still the same error. The computers in question run the following versions of excel: Excel 2000 (9.0.6926 SP-3) Excel 2000 (9.0.3821 SR-1) Excel 2000 (9.0.2720) I thought it might be a versioning issue (I developed the macro in Excel 2002), but one other instance of Excel 2000 (9.0.6926 SP-3) runs the macro fine. Does anyone know if something would block the Activate method in Excel? The worksheet in question is actually a tab-delimited file that is opened with excel. Chris Bloom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel worksheet linking | Excel Worksheet Functions | |||
| Rename Excel Worksheet | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions | |||
| Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions | |||
Threaded Mode
