Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Sheets.Select" won't work if some sheets are hidden...

Status
Not open for further replies.
bodo62

bodo62

Programmer
Jun 29, 2004
23
SE
Hi.

I've got a workbook with several worksheets and charts. The charts are based on information from hidden worksheets. I need to select all remaining visible sheets (they are worksheets and charts), and from the group of sheets make a setup for page header and footer as well as printing the whole set to specific printer.

I thought Sheets.Select would select all remaining sheets, but it doesn't work because some sheets are hidden.

I tried also Charts.Select and of course this one will work, but there still are 2 visible worksheets that I want to select together with the charts. How could I solve this problem?

Tanks in advance for any bit of help.

 
Sort by date Sort by votes
If the sheets are hidden they can only be accessed by using the Activate method as in Sheets(1).Activate

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Niki_S
  • Locked
  • Question
Error in Excel/VB6 function: "Constant expression required"
2
Replies
31
Views
502
strongm
strongm
Andrzejek
  • Locked
  • Question
Word shows up even if Visible = False 1
Replies
2
Views
132
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
START mycode if on clck on msflexgrid 1
Replies
2
Views
101
2009luca
2009luca
sal21
  • Locked
  • Question
check if i have clicked on header column name GIORNI 1
Replies
8
Views
186
strongm
strongm
versof
  • Locked
  • Question
What is a "Public Object Module
Replies
3
Views
142
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top