Re: User forms
- From: "macropod" <invalid@xxxxxxxxxxxxxxx>
- Date: Tue, 25 Mar 2008 17:30:45 +1100
Hi Bob,
Which version of Excel are you using? Excel 2000 and later are modal by default, but you can choose between modal and modeless by setting the vbModal and vbModeless properties - see the 'Show method' in the Help file for details. Excel '97 doesn't support the modeless state.
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
"Bob" <someonw@xxxxxx> wrote in message news:%23qEWbodjIHA.484@xxxxxxxxxxxxxxxxxxxxxxx
Hi Everyone:
In excel when you create an user form, it is always modal. Is there anyway to make it non-modal so that when the form is displayed, the user to be able to click on the spread*** and access it (very similar to the dialog box for the chart). Thanks for your help.
Bob
.
- Follow-Ups:
- Re: User forms
- From: Bob
- Re: User forms
- References:
- User forms
- From: Bob
- User forms
- Prev by Date: Re: Change hyperlink in all office files
- Next by Date: Re: Add-in Directory
- Previous by thread: User forms
- Next by thread: Re: User forms
- Index(es):
