Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an old Excel Add-in (XLA) developed in Office 95/97.
I need to edit the dialogs in the Add-in. The dialogs are designed in Dialog Sheets (old style, before User Forms was an option). My problem is that I can't see those dialogs anywhere. I have tried many different approaches I have found on the net without success. I will try to describe as much as possible and hopefully someone can help me. The project is password protected, so before I do anything else I open the project in Visual Basic Editor opened from Excel and enter the code (I have tried to disable the protection but it doesn't make any difference). If I open Visual Basic editor, and drop down the project I can see "ThisWoorkbook". I right click on it and choose "Show objects". I then gets to Excel with the Woorkbook open (I guess). If I take File-Properties and look under Contents Tab I can see my dialog name there. So it exists. And the dialog is working when I run the Add-in as well. If I try Format-Unhide and chooses my dialog nothing shows up. if I try Format-Change Name I get an edit box in Excel background making me able to change the name of the dialog, but that is as close as I get to editing it. I can't see the actual Dialog nor can I edit any controls in it. I tried to add the following code in the workbook: Private Sub Workbook_Open() Dim ds For Each ds In ThisWorkbook.DialogSheets ds.Visible = True MsgBox "Check" Next MsgBox "Done" End Sub When I open my Add-in I get the "Check" message several times, and the "Done" message as well. So it obviusly runs, but that didn't help either. I'm out of ideas and doesn't find any other possible options on the net or in any documentation. I have tried to edit the Add-in in both Excel 97 and Excel 2003. I hope someone can give me a hint on what to try next. Thanks in advance! /T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to edit query | Excel Discussion (Misc queries) | |||
Unable to edit formula | Excel Worksheet Functions | |||
unable to edit any of my workbooks | Excel Worksheet Functions | |||
Edit DialogSheets | Excel Programming | |||
unable to edit macro!!! | Excel Programming |