| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
runtime error 2147221005(800401f3)
Hi
I'm facing problem in ecexl once i open the work book , this below error runtime error 2147221005(800401f3) Invalid class string Private Sub Workbook_Open() Sheets("face").Select Range("A1").Select Application.ScreenUpdating = False Sheets("FOR").Select Range("A1").Select Load UserForm1 Application.ScreenUpdating = True UserForm1.Show End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
runtime error 2147221005(800401f3)
Why don't you step through your code and tell us exactly where it has an error.
"Deen" wrote: Hi I'm facing problem in ecexl once i open the work book , this below error runtime error 2147221005(800401f3) Invalid class string Private Sub Workbook_Open() Sheets("face").Select Range("A1").Select Application.ScreenUpdating = False Sheets("FOR").Select Range("A1").Select Load UserForm1 Application.ScreenUpdating = True UserForm1.Show End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
runtime error 2147221005(800401f3)
Don't know how much this will help, but it won't hurt to take a look.
http://www.linxent.com/articles/Erro...s%20String.htm "Deen" wrote in message ... Hi I'm facing problem in ecexl once i open the work book , this below error runtime error 2147221005(800401f3) Invalid class string Private Sub Workbook_Open() Sheets("face").Select Range("A1").Select Application.ScreenUpdating = False Sheets("FOR").Select Range("A1").Select Load UserForm1 Application.ScreenUpdating = True UserForm1.Show End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| runtime error 2147221005(800401f3) | Excel Worksheet Functions | |||
| runtime error 13 - type mismatch error in Excel 97 on Citrix | Excel Programming | |||
| runtime error '1004' application or object defined error. Please help | Excel Programming | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
| Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
Hybrid Mode
