Consulting

Results 1 to 2 of 2

Thread: VBA - Unhiding a Worksheet and setting Sheet1 as current view

  1. #1

    VBA - Unhiding a Worksheet and setting Sheet1 as current view

    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,

  2. #2
    All set it was easy... .Activate DOH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •