XL5 Macro function - getting worksheet status

[Ian Page]

.... I know, I know, I must be the last person in the world still using the
old XL5 macro language ...
1 "VBA learning curve"
2 "huge existing XL5 code"
3 "old dog .. new tricks" ;-)


Can any of the ancients tell me what function - eg. GET.????(type_code) -
will return the names of hidden worksheets, or, in particular, whether a
certain worksheet is hidden?

Surely this *must* be supported, no?
Both WORKBOOK.HIDE(sheet_text) and WORKBOOK.UNHIDE(sheet_text) both valid
functions. And they manipulate sheets, not workbooks...

 

[Jim Gordon MVP]

Hi Ian,

This question is not Mac specific, so I'm cross posting to the
excel.programming newsgroup to see whether anyone there has the answer.

-Jim

 

[Gary Brown]

'/=====================================/
Sub HiddenSheets()
Dim iSheets As Long, x As Long
iSheets = ActiveWorkbook.Sheets.Count

For x = 1 To iSheets
If Sheets(x).Visible = False Then
MsgBox Sheets(x).Name & " is hidden."
End If
Next
End Sub
'/=====================================/

HTH,
Gary brown

 

[Fredrik Wahlgren]

... I know, I know, I must be the last person in the world still using the
old XL5 macro language ...
1 "VBA learning curve"
2 "huge existing XL5 code"
3 "old dog .. new tricks" ;-)


Can any of the ancients tell me what function - eg. GET.????(type_code) -
will return the names of hidden worksheets, or, in particular, whether a
certain worksheet is hidden?

Surely this *must* be supported, no?
Both WORKBOOK.HIDE(sheet_text) and WORKBOOK.UNHIDE(sheet_text) both valid
functions. And they manipulate sheets, not workbooks...

You're not the last last person in the world still using the old XL5 macro
language. The Excel4 API still relies on the old macro language. The API is
of interest to those that wish to make Excel add-ins using C/C++.

/Fredrik

 

[Jim Gordon MVP]

Fred,

If you see this, please let us know if you have information about how to
go about making C/C++ add-ins. The question has arisen a few times in
the Mac Excel newsgroup lately.

Thanks.

 

[Fredrik Wahlgren]

Fred,

If you see this, please let us know if you have information about how to
go about making C/C++ add-ins. The question has arisen a few times in
the Mac Excel newsgroup lately.

Thanks.

--
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>

I haven't tried this with the latest version of Excel. The last time I did
was with Excel version 5. I then wrote 68k CODE resources. The add-ins that
come with Excel nowadays seems to be shared libraries except for one xll. I
haven't been able to figure out how shared libraries interact with Excel. If
I manage to write some kind of add-in, I will mention it to the Mac Excel
newsgroup.

Best Regards,
Fredrik