LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to detect if a workbook is hidden through VBA

Hello all:

I recently created code that lists all open files in Excel (.xls or
otherwise) and then moves the ActiveSheet for each open file to after the
active sheet in the active workbook. In addition, all of my code is kept in
a separate workbook which is hidden and loads on startup of Excel (so I can
access the code on any other open workbook).

The move process works great unless a hidden workbook is loaded in Excel
(i.e. my code workbook). When the code encounters the hidden workbook it
halts after attempting the move and my code workbook is closed
automatically.

I need to identify which open workbooks are hidden so I can skip them in the
move. Lots of help exists regarding hidden worksheets but not workbooks and
the VBA object browser does list a hidden property of a workbook.

Any suggestions?

Thanks,
Aaron


 
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
How do I detect hidden worksheets or hidden data on a worksheet? Alice Excel Discussion (Misc queries) 4 August 24th 06 03:38 AM
How to detect if sheet is hidden? hstijnen Excel Worksheet Functions 1 March 24th 05 02:40 PM
Detect Workbook Name when using GetOpenFileName Chris Gorham Excel Programming 2 December 15th 04 04:31 PM
How to hide a workbook and to detect a hidden workbook in visual basic jn1971[_3_] Excel Programming 0 May 5th 04 10:08 PM
Detect more info when workbook does not ack right. Tom Ogilvy Excel Programming 0 July 11th 03 02:34 PM


All times are GMT +1. The time now is 10:32 PM.

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

About Us

"It's about Microsoft Excel"