Spudwise
July 12th, 2001, 11:02 AM
Greetings,
Here's the scenario - I have a small user form floating above a Excel Worksheet. The user clicks a command button, and I need some code or a method to shift focus, from the button just clicked, back to the Active Worksheet - just as if the user clicked the worksheet itself with the mouse. I've tried making a cell Active or Select, neither does what I need. Any ideas?
Thanks,
Ken
Here's the scenario - I have a small user form floating above a Excel Worksheet. The user clicks a command button, and I need some code or a method to shift focus, from the button just clicked, back to the Active Worksheet - just as if the user clicked the worksheet itself with the mouse. I've tried making a cell Active or Select, neither does what I need. Any ideas?
Thanks,
Ken