Sheet HIde and Unhide and go to Specific Cell

ArhamRajput · May 20th 2020

Dear Team,

I am looking for a code when i press a button to initiate the code then hide sheet should be open and should go to on desired cell as hyperlink work.

after that when i press other button to go back then sheet should be hide.

is it possible.

**alansidman** · May 20th 2020

**royUK** · May 21st 2020

You don't say which kind of button. This is for an ActiveX CommandButton, you can adapt the code for your use.

Code

Private Sub CommandButton1_Click()
Application.Goto Reference:=Worksheets("Sheet2").Range("A1"), _
Scroll:=True
End Sub

ArhamRajput · May 22nd 2020

Thank you so much Roy.

I just need that code will add button later right now not need.

**royUK** · May 22nd 2020

Why do you need to add the button?

ArhamRajput · May 22nd 2020

Please look at this report when i click on the button hide sheet is appear and when i go back then it is disappear.

Thank you for your consistent support.

**royUK** · May 23rd 2020

You have 3 buttons, each one opens a sheet. When you return to the main sheet the buttons are still there.

I can't understand why you don't simply use hyperlinks.

ArhamRajput · May 27th 2020

Apologise for replying late.

When i press the button it unhide the sheet when go back then automatically sheet goes hide. i want this and you helped me.

**royUK** · May 27th 2020

Is it working correctly?

ArhamRajput · May 27th 2020

Yes it is.

**royUK** · May 27th 2020

That's good. Pleased to help.

Participate now!