Access to spreadsheets with VBA User Form up

's Computer Specifications

I have a User Form I built in VBA for Excel. When it is active/
displayed, I am unable to display any Excel spreadsheets it has used
(still open).

Is there a way around this? Thanks, Alan

's Computer Specifications

Do you mean unable to interact, rather than display, spreadsheets?

The default open mode for UserForm.show is Modal, to allow interaction with
other objects you need to open it Mode Less.

Use something like....

UserForm1.Show (0)

--

Regards,
Nigel
(E-Mail Removed)

"Alan" <(E-Mail Removed)> wrote in message
news:7461a9aa-17e1-4255-87d0-(E-Mail Removed)...
> I have a User Form I built in VBA for Excel. When it is active/
> displayed, I am unable to display any Excel spreadsheets it has used
> (still open).
>
> Is there a way around this? Thanks, Alan
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating multiple spreadsheets from form in access.	=?Utf-8?B?QUo=?=	Microsoft Access VBA Modules	5	29th Aug 2007 06:02 PM
Creating multiple spreadsheets from form in access.	=?Utf-8?B?QUo=?=	Microsoft Access Forms	2	28th Aug 2007 06:28 PM
Creating multiple spreadsheets from form in access.	=?Utf-8?B?QUo=?=	Microsoft Access Forms	0	28th Aug 2007 12:42 AM
Linking an Access Form to a Word Document with a User Form on Open	=?Utf-8?B?Q2hyaXM=?=	Microsoft Access Macros	0	14th Sep 2006 12:21 AM
Re: Modeless User Form in Access '97	Chip Pearson	Microsoft Excel Programming	0	15th Mar 2004 03:22 PM