Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a little code issue that is likely quite easy for someone experienced in VBA. I have written this code: Private Sub Workbook_Open() Workbooks.Open ("document link here") 'Application.ActiveWorkbook.Visible=False This is the bad line! Application.ActiveWorkbook.Close End Sub Basically, upon opening one workbook, I open another, as well and this is working fine. However, I do not want the second workbook to show at all during this process (note the commented out code). This commented code doesn't work but is likely close. Any ideas on the correct syntax for this line? I have tried a few different ways to no avail. Your help is appreciated, -- Michael J. Nowak Texas City, TX |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
showing links when opening | Excel Discussion (Misc queries) | |||
showing picture upon opening file | Excel Discussion (Misc queries) | |||
opening a worksheet without showing excel components | Excel Worksheet Functions | |||
run the macros without opening or showing the excel sheet | Excel Programming | |||
run the macros without opening or showing the excel sheet | Excel Programming |