J
JK
I developed an application with a custom toolbar that includes Preview
Reports. When clicked the appropriate WS appears (also with a custom
toolbar) that attempts to mimic Excel's print preview. As a result, I wrote
ActiveWindow.DisplayWorkbookTabs = False. When the preview is closed,
ActiveWindow.DisplayWorkbookTabs = True. However, (though tabs reappear)
they occassionally disappeared when a WS was activated. To get around it I
included ActiveWindow.DisplayWorkbookTabs = True for all WS that are
activated. That works, however, sometimes when a WB is saved and reopened
the tabs aren't there. Any ideas? Perhaps a sure-fire macro to mimic Print
Preview that assures the tabs reappear (always)?
TIA
Jim Kobzeff
Reports. When clicked the appropriate WS appears (also with a custom
toolbar) that attempts to mimic Excel's print preview. As a result, I wrote
ActiveWindow.DisplayWorkbookTabs = False. When the preview is closed,
ActiveWindow.DisplayWorkbookTabs = True. However, (though tabs reappear)
they occassionally disappeared when a WS was activated. To get around it I
included ActiveWindow.DisplayWorkbookTabs = True for all WS that are
activated. That works, however, sometimes when a WB is saved and reopened
the tabs aren't there. Any ideas? Perhaps a sure-fire macro to mimic Print
Preview that assures the tabs reappear (always)?
TIA
Jim Kobzeff