Hello,
When the command button is selected to open a worksheet in the workbook, the sheet opens but does not have the focus - it is behind the main sheet that the command button is on - how do i get the sheet that was needed to be the focus when selecting the command button
Best Regards,
John
Last edited by JJFletcher; 11-05-2014 at 10:08 AM.
Add the Line:
to the Command Button.
Please Login or Register to view this content.
"Sheet2" is the sheet you are opening.
If the solutions provided within this Thread takes care of your question:
Please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
You can also click on * (star) Add Reputation to add reputation to those who have put their time and efforts to help you in this Thread.
This is another way to say Thank You to them.
What do you mean by "open a worksheet" and "it is behind the main sheet"?
Post your code or, better, a sample workbook with it in situ.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I have a spreadsheet that has a command button on it that when selected - opens another spreadsheet - once selected - that sheet does open - but it does not have focus - the spreadsheet that has the command button is visible and I want the 2nd spreadsheet to be visible
Thanks
Opens a Spreedsheet in the same Workbook or in a new WorkBook?
So, by spreadsheet, do you mean workbook? Like I said, post your code.
The Only way you would not have Focus is if the Command button is on a Userform?? Or?
If this is the case then just add theas the last line in the command button.Please Login or Register to view this content.
If the Command button is on the Sheet then you Focus on the new WorkSheet/WorkBook.
command button is on the spreadsheet - not a userform
My applogies - I am at work and will post the sample later Be back soon!
hello - I have returned - it's simple ---
I have a spreadsheet that has a command button on it that when selected - opens another spreadsheet in the same workbook - once selected - that sheet does open - but it does not have focus - the spreadsheet that has the command button is visible and I want the 2nd spreadsheet to be in front of the spreadsheet that opened the 2nd sheet
Post the code.
Part of our difficulty in understanding your problem is that "spreadsheet" is imprecise. Are you opening a different workbook or a different worksheet in the same workbook.
Post the code.
Or attach you workbook.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
different worksheet in the same workbook
Here is the sample workbook requested
TestSample.xlsm
John
Last edited by JJFletcher; 11-06-2014 at 01:41 AM.
Does this upload explain? - The second sheet I want to have the focus when opened
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks