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
.
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.
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 = FalseIt 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.
