Solved: Dialog Sheets

[jammer6_9]

How can I set Dialog Sheet(Frame) to show in Center Screen Only and restrict user not move it...

[Jan Karel Pieterse]

Why would you use such an ancient technology (dialog sheets go back to Excel 5/95)?

[jammer6_9]

:rotlaugh: A project was pass on to me where it has 27 dialog sheets. Me eitther is not used to it. So then I have to change all dialog sheets to userform :banghead: ... Well then thanks for the advice...


Why would you use such an ancient technology (dialog sheets go back to Excel 5/95)?

[Paul_Hossler]

Haven't tried this free add-in, but Baarns has some other add-ins that I've used and like

http://archive.baarns.com/download/Dlg_Conv.exe

One of the most important changes to Excel 97 VBA is the addition of a true Forms package. In order to take advantage of this powerful new feature you must convert all of your Excel 5/95 Dialog sheets into Excel 97 UserForms. The Excel 97 Dialog Converter takes most of the hassle out of this process by automatically converting the structure of your Excel 5/95 Dialog sheets and their controls into new Excel 97 UserForms with corresponding ActiveX controls.

Paul

[jammer6_9]

Perfect... Thanks Paul :friends:


Haven't tried this free add-in, but Baarns has some other add-ins that I've used and like

http://archive.baarns.com/download/Dlg_Conv.exe

One of the most important changes to Excel 97 VBA is the addition of a true Forms package. In order to take advantage of this powerful new feature you must convert all of your Excel 5/95 Dialog sheets into Excel 97 UserForms. The Excel 97 Dialog Converter takes most of the hassle out of this process by automatically converting the structure of your Excel 5/95 Dialog sheets and their controls into new Excel 97 UserForms with corresponding ActiveX controls.

Paul