Hidden Worksheet

  • Thread starter Thread starter RJG
  • Start date Start date
R

RJG

I have put a button on a summary worksheet to go to a 2nd worksheet
and this works fine. However i have now hidden the 2nd worksheet and
my simple code will nolonger find it.
Can I still use the button (but just amend the code) if the 2nd
worksheet is "hidden". Or do I have to unhide the sheet for it to
work.
This is the simple code that i am using, can it be changed

Private Sub CommandButton3_Click()
Sheets("BIC code summary").Select
End Sub



Bob

ps I also have another button on the hiden sheet to return to the
original sheet.
 
Change you macro to
Sheets("BIC code summary").Visible = True
Sheets("BIC code summary").Select

On the button to return if you want to hide it again then add
Sheets("BIC code summary").Visible = false

Mike
 
Mike,
Perfect, thank you

Bob

Change you macro to
Sheets("BIC code summary").Visible = True
Sheets("BIC code summary").Select

On the button to return if you want to hide it again then add
Sheets("BIC code summary").Visible = false

Mike
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hidden sheet bleeds through 3
Identify Hidden Columns - New issue! 19
Copy Template with Updated Values Each Time 0
hyperlinking to charts in file 1
Hide worksheet when moving back to another sheet 2
Can't delete sheets 8
Error Message - Macro to Unlink MS Queries from Workbook 0
Set Active Cell to A1 on Open Q 3

Back
Top