Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 921
Default How to keep a workbook visible

I have a workbook that I'd like to be set to stay visible even if
programatically its tolde to hide. Is that possible?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default How to keep a workbook visible

There is no visibility event, so I wouldn't think so.

You could possibly use some other event to periodically set its visible
attribute to true.

Chip Pearson's page on Events
http://www.cpearson.com/excel/events.htm
on Application Level events
http://www.cpearson.com/excel/appevent.htm


--
Regards,
Tom Ogilvy



"Jeff" wrote in message
...
I have a workbook that I'd like to be set to stay visible even if
programatically its tolde to hide. Is that possible?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default How to keep a workbook visible

You could delete/comment out the part of the macro that hides it. Or, have
another macro to make it visible after the 1st macro hides it.
This is curious??

--
Don Guillett
SalesAid Software

"Jeff" wrote in message
...
I have a workbook that I'd like to be set to stay visible even if
programatically its tolde to hide. Is that possible?



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default How to keep a workbook visible

Jeff

if application.enableevents is not set to false somewhere
...then I think following eventhandler in ThisWorkbook would solve it.

Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
Wn.Visible = True
End Sub

hth


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jeff wrote :

I have a workbook that I'd like to be set to stay visible even if
programatically its tolde to hide. Is that possible?

Reply
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
Workbook Open but not visible (and not HIDDEN?!?) mcleester Excel Discussion (Misc queries) 0 December 30th 08 03:02 PM
Excel 2007 Workbook Not Visible willhandley Excel Discussion (Misc queries) 1 August 27th 07 03:29 PM
3 sheets in workbook, but visible only one? slaya_cz Excel Discussion (Misc queries) 3 September 30th 05 01:37 PM
VBAProjects still visible after workbook has closed R Avery Excel Programming 1 May 23rd 04 01:34 AM
Is a visible workbook open? pk Excel Programming 1 October 4th 03 12:47 AM


All times are GMT +1. The time now is 03:32 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"