| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping a workbook hidden when opened via VBA???
Hi all, Does anyone know how to keep a workbook hidden that is opened via VB and visible when opened normally i.e with a double left click or fro choosing File and then Open?? Simo -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=26681 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keeping a workbook hidden when opened via VBA???
Have a look the Caller property in help. If the Caller
is "An Auto_Open, Auto_Close, Auto_Activate, or Auto_Deactivate macro" you could make the activewindow.visible property false. Geof. -----Original Message----- Hi all, Does anyone know how to keep a workbook hidden that is opened via VBA and visible when opened normally i.e with a double left click or from choosing File and then Open?? Simon -- Simon Lloyd ---------------------------------------------------------- -------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=266818 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keeping a workbook hidden when opened via VBA???
In the VBA that opens the workbook, simply hide it with:
--------------------------------------------------------- ActiveWindow.Visible = False or Windows("WorkbookName.xls").Visible = False --------------------------------------------------------- Then, in the now hidden workbook's close code, do this: ------------------------------------------------------------- Private Sub Workbook_BeforeClose(Cancel As Boolean) Windows("WorkbookName.xls").Visible = True End Sub ------------------------------------------------------------- Good Luck CB Hamlyn "Simon Lloyd" wrote in message ... Hi all, Does anyone know how to keep a workbook hidden that is opened via VBA and visible when opened normally i.e with a double left click or from choosing File and then Open?? Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=266818 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keeping a workbook hidden when opened via VBA???
If you open it in VBA, then hide it with the same code. If you don't save
it, then it should be visible next time it is opened. -- Regards, Tom Ogilvy "Simon Lloyd" wrote in message ... Hi all, Does anyone know how to keep a workbook hidden that is opened via VBA and visible when opened normally i.e with a double left click or from choosing File and then Open?? Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=266818 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
| Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
| Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
| How to see if the opened workbook is opened by another user ? | Excel Programming | |||
| keeping rows hidden in outline | Excel Programming | |||
![Simon Lloyd[_585_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
