Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbook Open but not visible (and not HIDDEN?!?) | Excel Discussion (Misc queries) | |||
Excel 2007 Workbook Not Visible | Excel Discussion (Misc queries) | |||
3 sheets in workbook, but visible only one? | Excel Discussion (Misc queries) | |||
VBAProjects still visible after workbook has closed | Excel Programming | |||
Is a visible workbook open? | Excel Programming |