ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deleting ActiveX Controls (https://www.excelbanter.com/excel-programming/279740-deleting-activex-controls.html)

Ron[_12_]

Deleting ActiveX Controls
 
Hello,

I'm having trouble with some ActiveX Calendar controls.

I don't have the computer where the error is occurring with me so I
can't give the exact error message.

But here are the basics:

1) WinXP & OfficeXP
2) Sheet with 2 ActiveX Calendar controls
3) Sheet is hidden after macro has run
4) When the workbook is opened a message comes up about Initializing
an ActiveX control
5) When I try to delete the controls or the sheet they are on Excel
crashes!!

Please help, TIA,

Ron

Tom Ogilvy

Deleting ActiveX Controls
 
Try deleting them as the first action upon opening. Possibly do it through
the immediate window of the VBE.

Perhaps open the workbooks and delete the controls using a macro from
another workbook.

--
Regards,
Tom Ogilvy

"Ron" wrote in message
om...
Hello,

I'm having trouble with some ActiveX Calendar controls.

I don't have the computer where the error is occurring with me so I
can't give the exact error message.

But here are the basics:

1) WinXP & OfficeXP
2) Sheet with 2 ActiveX Calendar controls
3) Sheet is hidden after macro has run
4) When the workbook is opened a message comes up about Initializing
an ActiveX control
5) When I try to delete the controls or the sheet they are on Excel
crashes!!

Please help, TIA,

Ron





All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com