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?

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?

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?

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?