Unable to edit DialogSheets in XLA

[T G]

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

 

[Peter Huang [MSFT]]

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/subscriptions/managednewsgroups/default.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/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

 

[Peter Huang [MSFT]]

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.