HotXLS-dokumentasjon
Hjem Innhold Oversikt

Visible egenskap

Determines whether the Worksheet is visible. Read/write Variant

Syntaks

property Visible: Variant;

Beskrivelse

Visible can be one of these constants
xlSheetHidden
xlSheetVisible
xlSheetVeryHidden Hides the sheet so that the only way for you to make it visible again is by setting this property to True or xlSheetVisible (the user cannot make the sheet visible)

Eksempel

This example makes the Worksheet one invisible 

Workbook.Sheets[1].Visible := False;
This example is the same to previous 

Workbook.Sheets[1].Visible := xlSheetHidden;
This example checks visibility of sheet one 

With Workbook.Sheets[1] do begin
  if Visible = xlSheetVisible then
     Name := 'Visible Sheet'
  else
     Name := 'InVisible Sheet';
end;