Can i hide the sheet through VBA coding

  • Thread starter Thread starter kvenku
  • Start date Start date
Hi Venkatesh,

Activesheet.Visible = xlHidden 'xlVisible restores it



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Of course, you can't hide it if it's the only sheet in the workbook.
 
Vasant Nanavati said:
Of course, you can't hide it if it's the only sheet in the workbook.
Click to expand...

Through VBA coding ?

Sub SheetsGone()
ThisWorkbook.IsAddin = True
End Sub

;-)
Best wishes Harald
 
You can make it a lot less visible, though <g>

With Workbooks("Book1").Worksheets("Sheet1")
.Rows.Hidden = True
.Columns.Hidden = True
End With
 
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

Hide sheets 6
Hyperlink to Same sheet but after that want to hide link sheet 1
VBA Countif across sheets? 5
Language independent VBA - hiding "blank" in pivot? 1
If statement based on cell formatting/style 2
before save event 2
Hide Sheets when closing file 2
Hiding / locking access to VBA code 2

Back
Top