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

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

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

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

ok, thanks for the idea, chip.

--


Gary


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