PDA

View Full Version : VBA - Unhiding a Worksheet and setting Sheet1 as current view



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,

pawcoyote
07-03-2019, 09:28 AM
All set it was easy... .Activate DOH