LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.mac.office.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default XL5 Macro function - getting worksheet status

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

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


Ian Page wrote:
... 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...

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cant use sum function or status bar Medways Excel Discussion (Misc queries) 1 August 22nd 09 09:12 AM
worksheet tabs are cut off and can't see status bar MMcC Excel Worksheet Functions 2 August 21st 09 02:13 AM
Worksheet Protection status JimB Excel Worksheet Functions 1 September 28th 06 11:02 PM
Worksheet protection status JimB Excel Discussion (Misc queries) 0 September 28th 06 10:03 PM
Add a function to the status bar? [email protected] Excel Discussion (Misc queries) 1 July 17th 06 07:37 PM


All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"