Selecting a hidden sheet VBA

[BenNV]

Hello!

I use the following command in VBA:
Sheets("Sheet1").Select

But I would like to hide sheet1. What changes do I make to the code as I get many code errors.

 

[Richie(UK)]

Hi,

Try one of these:

Worksheets("Sheet1").Visible = False
'normal Hide, or
Worksheets("Sheet1").Visible = xlVeryHidden
'very hidden

HTH

 

[BenNV]

thanks Ritchie. I've managed to hide the sheet. But in my code I previously used: Sheets("Sheet1").Select and now that I have hidden Sheet1 the code doesn't work.

 

[Richie(UK)]

On 2003-01-13 10:13, BenNV wrote:
... I've managed to hide the sheet. But in my code I previously used: Sheets("Sheet1").Select and now that I have hidden Sheet1 the code doesn't work.

You can't select or activate a sheet that is hidden. However, you don't usually need to do this in order to carry out an action on a sheet. What are you trying to do?

 

[BenNV]

I am trying to do various selections, pastes, copying, and calculations on particular sheets, which is why I'm trying to select the sheet beforehand.

Maybe I should make the sheet visible before and then once the code is finished, change it to hide.

 

[Richie(UK)]

Hi Ben,

You have two options.

1. As you said, carry out your actions first and then hide the sheet.

2. Just work with the sheet rather than selecting or activating it. This is the preferred method. Eg.
<pre>Sub Test()

With Worksheets("Sheet1")
.Visible = False
'normal Hide
.Range("A1:F20").Copy
End With

Worksheets("Sheet2").Range("A1").PasteSpecial

End Sub</pre>HTH

 

[Ahmed998877]

Hello!

I use the following command in VBA:
Sheets("Sheet1").Select

But I would like to hide sheet1. What changes do I make to the code as I get many code errors.

Hello - i am stacked with same Problem - have you found a solution ?