VbModeless help

TomBagley

New Member
Joined
Aug 29, 2012
Messages
6
Hi guys,

I currently have a userform that takes data, posts onto a spreadsheet and is used to create reports.

To run the form as an application on colleagues' desktops I am currently hiding Excel while the macro runs using
Code:
ThisWorkbook.Application.Visible = False
.


It has become apparent that the use of other spreadsheets in conjunction with the macro is a must and I recently made the form modeless.


This worked fine except when another workbook is opened, the sheet behind the userform becomes visible and does not re-minimize.

I am unsure whether this is down to the order my code has been placed or whether anything addtional needs to be added to keep the sheet hidden.


All your help is greatly appreciated as always. :biggrin:
 

Forum statistics

Threads
1,082,480
Messages
5,365,798
Members
400,854
Latest member
zenith_11

Some videos you may like

This Week's Hot Topics

Top