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
...
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" wrote in message
...
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
...
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