LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
T G T G is offline
external usenet poster
 
Posts: 4
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to edit query harriettbird Excel Discussion (Misc queries) 0 May 4th 06 02:10 PM
Unable to edit formula Jennifer H Excel Worksheet Functions 6 March 9th 06 04:27 AM
unable to edit any of my workbooks dljdd Excel Worksheet Functions 1 January 24th 06 01:56 AM
Edit DialogSheets Herb[_6_] Excel Programming 6 April 18th 04 06:53 PM
unable to edit macro!!! john Excel Programming 3 January 9th 04 03:31 PM


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"