BOUNDSHEET: Sheet Information (85h)

This record stores the sheet name, sheet type, and stream position.

BIFF8 Record Data

Offset

Name

Size

Contents

4

lbPlyPos

4

Stream position of the start of the BOF record for the sheet

8

grbit

2

Option flags

10

cch

2

Length of the sheet name

12

rgch

var

Sheet name


BIFF7 Record Data

Offset

Name

Size

Contents

4

lbPlyPos

4

Stream position of the start of the BOF record for the sheet

8

grbit

2

Option flags

10

cch

1

Length of the sheet name

11

rgch

var

Sheet name


The grbit field contains the options listed in the following table.

Offset

Bits

Mask

Name

Contents

0

7 – 0

0Fh

dt

Sheet type:
00h = worksheet or dialog sheet
01h = Microsoft Excel 4.0 macro sheet
02h = chart
06h = Visual Basic module

1

1–0

03h

hsState

Hidden state:
00h = visible
01h = hidden
02h = very hidden (see text)

7 – 2

FCh

(Reserved)


A Visual Basic procedure can set the Visible property of a sheet to create a very hidden sheet. A very hidden sheet can be made visible again by a Visual Basic procedure, but there is no way to make the sheet visible through the user interface of Microsoft Excel.