View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default Hide one sheet tab

Tempy,

Worksheets("TBSheet"").Visible = xlVeryHidden

You're not a Van Morrison fan by any chance are you?

hth,

Doug

"Tempy" wrote in message
...
Hi all, is it possible to hide just one tab in a workbook ?
I have a workbook "Recon.xls" with the sheets "Recon for SAP" and
"TBSheet" and i would like to hide "TBSheet"

Thank you in advance,

Tempy

*** Sent via Developersdex http://www.developersdex.com ***