How to keep a workbook visible

[Guest]

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

 

[Tom Ogilvy]

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

 

[Don Guillett]

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??

 

[keepITcool]

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 :