Access to spreadsheets with VBA User Form up
 

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

Access to spreadsheets with VBA User Form up
 

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




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