Thread: Hide one sheet tab
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Hide one sheet tab
Tempy

Manually.....FormatSheetHide

Programmatically.....

Sub Hide()
Sheets("TBSheet").Visible = False
End Sub


Gord Dibben Excel MVP

On Mon, 29 Aug 2005 13:52:04 -0700, Tempy wrote:

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 ***

Reply With QuoteReply With Quote