Need help with Excel dialog sheets

[Alexander.Kom]

I have to make some changes to an existing Excel VBA application. I was given a password with which I was able to unprotect the worksheets in the application in order to make necessary changes.
When I open the application, it starts running automatically with a dialog box showing up. My problem is that I need to unlock the dialog box so I could make changes to the controls and assigned macros but I have no idea how to do that since I am quite new to VBA. Can anyone please help me?

[Leith Ross]

Hello Alexander,

I am guessing here because I don't really know what you mean by "unlocking the Dialog Box". I suspect you can't find where it is. To view all the VBA objects and code you need to open the VBA Editor. To do this, press ALT + F11 while in Excel. Press CTRL + R to select the Project Explorer Window. This is a Tree View of the VBA objects and code modules. The Dialog Box should be in the "FORMS" node. Click on the "+" to expand the view. This will show you all the User Forms (Dialog Boxes) in the VBA Project.

Sincerely,
Leith Ross

[Alexander.Kom]

Hi Ross,
Thanks a million for responding to my question. What I meant by 'unlocking the dialog box' was to make it editalbe (i.e. to add more controls or remove some) just like we unprotect a dialog sheet to make changes to it. I tried your suggestion but there was no FORMS folder in my project explorer. I guess the program was created when Excel had dialog sheets instead of the USER FORMS we have now. Could it be that the forms and dialog sheets have been protected somewhere within the VBA code? If so how do I find out and unprotect them? Any more suggestion?

[Leith Ross]

Hello Alexander,

If you are using Excel '97, then your worksheet may be a "Dialog Sheet". I know they were used, but have never used nor encountered one these sheets. It can be protected by a password like a regular worksheet. That's really about all I know.

Sincerely,
Leith Ross

[Alexander.Kom]

Hi Ross,

Yes the original program was created in Excel 97 thats why its got those dialog sheets. I am using Excel 2003 now but don't know how to manipulate the dialog sheets. I hope I find some answer to this soon.
Anyway, I really appreciate your help.
Have a blessed day.

Alex