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
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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:%(E-Mail Removed)...
>> 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
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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:%(E-Mail Removed)...
>>> 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" <(E-Mail Removed)> wrote in message
news:921F777C-51CF-4A4C-BFF9-(E-Mail Removed)...
> 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:(E-Mail Removed)...
>>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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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:%(E-Mail Removed)...
>>>> 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
>>>>
>>>>
>>>>
>>>
>>
>>
>