Re: default form behavior

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

There is no way to change the default value. You could write an add-in with a command to insert a form with code like

Dim UF As Object
With Application.VBE.ActiveVBProject
Set UF = .VBComponents.Add(vbext_ct_MSForm)
UF.Properties("ShowModal").Value = False
End With


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"Gary Keramidas" <GKeramidasATmsn.com> wrote in message news:ORGsXeJ0HHA.6072@xxxxxxxxxxxxxxxxxxxxxxx
i know how to do it, i want the default property set to false every time i create a form, so i don't have to remember to do it..

--


Gary


"Chip Pearson" <chip@xxxxxxxxxxxx> wrote in message news:esakoOJ0HHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
Set the ShowModal property to False.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Gary Keramidas" <GKeramidasATmsn.com> wrote in message news:%23bYAF9I0HHA.3940@xxxxxxxxxxxxxxxxxxxxxxx
is there any way to change the default form behavior from modal to modeless. it's my own fault, but i end up losing more code when i create a form to perform a printpreview. i always forget to change it.

--


Gary







.

Quantcast