default form behavior

[Gary Keramidas]

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.

 

[Chip Pearson]

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]

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..

 

[Chip Pearson]

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]

ok, thanks for the idea, chip.

--


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)