Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to edit DialogSheets in XLA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to edit DialogSheets in XLA
Hi,
Based on test, it is strange that I did not find the related menu per your description. e.g. The "Show Objects", "Format-Unhide" Since Excel 97 is expired, I tested on Excel 2003. I tried to build a xla by saving a new excel workbook as .xla file, but if we add a dialog sheet into workbook, I can no longer save it as xla file. Also even for workbook objects, e.g. Sheet1,Sheet2,Sheet3, once we save it as xla file. Now we opened the xla, the workbook UI did not show, only the related code/object in the VBA Editor is available. Currently an you provide a simple reproduce steps, so that I can research the issue more efficiently. Thanks! If you still have any concern, please feel free to let me know Best regards, Peter Huang Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscripti...t/default.aspx. ================================================== (This posting is provided "AS IS", with no warranties, and confers no rights.) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to edit DialogSheets in XLA
Hi,
You are welcomed! If you still have any other questions, please feel free to post in the newsgroup. Best regards, Perter Huang Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |