oneblondebro
09-08-2017, 04:42 AM
Hi all,
Please see attached a Userform i have created with some help from online tutorials, I have 2 issue's which i cannot seem to fix and was wondering if you could help?
Issue 1, When i have multiple workbooks open and this workbook is not the Active one the userform wont work because it cannot find "Sheet 1", is there anyway to make the userform look for Sheet1 on this Workbook even if it's not the active workbook?
Issue 2, This one is really frustrating me, The coding allows the user to minimize the workbook but the CAPTURE TALLY userform stays visible and does not minimize, For some reason this does not work on my work computer (Accessed remotely), It minimizes the userform as well as the workbook, Any idea's how to get round this?
Thanks in advance for any help
Please see attached a Userform i have created with some help from online tutorials, I have 2 issue's which i cannot seem to fix and was wondering if you could help?
Issue 1, When i have multiple workbooks open and this workbook is not the Active one the userform wont work because it cannot find "Sheet 1", is there anyway to make the userform look for Sheet1 on this Workbook even if it's not the active workbook?
Issue 2, This one is really frustrating me, The coding allows the user to minimize the workbook but the CAPTURE TALLY userform stays visible and does not minimize, For some reason this does not work on my work computer (Accessed remotely), It minimizes the userform as well as the workbook, Any idea's how to get round this?
Thanks in advance for any help