Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
On my useform I have several objects like listbox, multipages and buttons, is it possible to ensure that if ANY object is clicked on a userform or the userform itself is clicked then the correct WORKBOOK that contains the useform will become the ACTIVE workbook.
Users are getting error messages, mainly due to the correct workbook not being the active workbook. This happens when the user has several workbooks open and the correct workbook with the userform IS NOT the active workbook the code crashes as script out of range.
Users are getting error messages, mainly due to the correct workbook not being the active workbook. This happens when the user has several workbooks open and the correct workbook with the userform IS NOT the active workbook the code crashes as script out of range.