Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi !
I have one Multipage with 6 pages. When I click on the last page, it opens a workbook from the Server. But when people click on any other page instead of last one, I need a command to close this activeworkbook. I tried in "Select Case" but it doesn't help me, because I will have to change the body of the program... I just needed something like: IF ACTIVEWORKBOOK IS DIFFERENT FROM THIS WORKBOOK THEN ACTIVEWORKBOOK.CLOSE FALSE I just do not get the right syntax... And if someone has a tip to give me about closing this recently opened file in case someone choose another page, please feel free, it would help me a lot ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB Syntax to close Excel workbook not saving changes | Excel Programming | |||
Hide all Sheets in Workbook then Close Workbook | Excel Programming | |||
Open New Workbook / Save and Close Current Workbook | Excel Programming | |||
Help on Workbook close and workbook save events | Excel Programming | |||
Close a the current workbook and load another specified workbook | Excel Programming |