| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error €˜-2147417848(8001
hello all,
i've simple form to delete sheets and i have the following code: Private Sub CommandButton1_Click() Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets(UserForm1.ComboBox1.Value).Delete UserForm1.Hide Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub when i click commandbutton1 the following error appear and excel is cranshing Run-time error €˜-2147417848(80010108): Automation error The object invoked has disconnected from its clients. i use excel2007 but i run this macro with file ( xls) not (xlsx) or (xlsm). thanks in advance atef |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run-time error €˜-2147417848(
Hi
I tried your code in an empty workbook and your code works just fine in XL2007. Do you have any links or references in other sheets to the sheet which you tries to delete? Regards, Per "Atef g" <Atef skrev i meddelelsen ... hello all, i've simple form to delete sheets and i have the following code: Private Sub CommandButton1_Click() Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets(UserForm1.ComboBox1.Value).Delete UserForm1.Hide Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub when i click commandbutton1 the following error appear and excel is cranshing Run-time error €˜-2147417848(80010108): Automation error The object invoked has disconnected from its clients. i use excel2007 but i run this macro with file ( xls) not (xlsx) or (xlsm). thanks in advance atef |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run-time error €˜-2147417848(
That message is related to an SQL activity when Excel disconnects from the
web page or another application. Where does ComboBox1 get its values from? "Atef g" wrote: hello all, i've simple form to delete sheets and i have the following code: Private Sub CommandButton1_Click() Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets(UserForm1.ComboBox1.Value).Delete UserForm1.Hide Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub when i click commandbutton1 the following error appear and excel is cranshing Run-time error €˜-2147417848(80010108): Automation error The object invoked has disconnected from its clients. i use excel2007 but i run this macro with file ( xls) not (xlsx) or (xlsm). thanks in advance atef |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run Time Error 2147417848 - 80010108 method Copy of Object Range F | Excel Programming | |||
| Run-time error-2147417848 (8001 | Excel Programming | |||
| Macro does not work after the program has been restarted in excel.Run time error 2147417848 (80010108) Method visible of object_worksheet failed | Excel Programming | |||
| Excel Bug: Run-time error '-2147417848 (80010108)' | Excel Programming | |||
| Run time error 2147417848(80010108) | Excel Programming | |||
Linear Mode
