![]() |
Userform
I have a userform with buttons. When a button is clicked,
and the code associated with that button finishes running, I want the userform to be deactivated (but still remain visiable), with the underlying worksheet made active. I've tried activating the worksheet within the code, and selecting a cell in the underlying worksheet within the VBA code associated with the button, but the userform still remains active after the code finishes running. That is, the user must physically click on a cell or range in the worksheet for the focus to shift from the userform back to the worksheet. Any ideas on how I can do this in the VBA code? Thanks!! |
All times are GMT +1. The time now is 11:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com