View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Hiding worksheet

Sheets("Sheet1").Visible = True


Gord Dibben MS Excel MVP

On Tue, 28 Jul 2009 08:51:01 -0700, rslaughter5
wrote:

after using xlVeryHidden, how would I unhide the sheet in my workbook?

"Mike H" wrote:

Hi,

To hide it use

Sheets("Sheet1").Visible = False

or to prevent someone simply unhiding it use

Sheets("Sheet1").Visible = xlVeryHidden

Mike

"Link" wrote:

Is there any way you can hide a worksheet in a workbook?