pawcoyote
07-03-2019, 08:39 AM
Hi all,
I have the code for hiding and unhiding my worksheets all set. But what is happening is when I click on the button to "Unhide" the worksheets it always moves my view to the last worksheet in the workbook. I want my view to stay on the current worksheet that has the buttons and that I was on. I am sure this is very easy but I am having a bugger of a time finding the code to stay on the current worksheet.
Thanks,
I have the code for hiding and unhiding my worksheets all set. But what is happening is when I click on the button to "Unhide" the worksheets it always moves my view to the last worksheet in the workbook. I want my view to stay on the current worksheet that has the buttons and that I was on. I am sure this is very easy but I am having a bugger of a time finding the code to stay on the current worksheet.
Thanks,