| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Windows Visible Property - Code Help
Thanks, again!
-- Thanks, Gerry O. "Jim Thomlinson" wrote: The reference (index) to the Window does not include the full path to the file so you are barking up the wrong tree on that one. Here is something similar you could try... Dim wnd As Window Set wnd = ActiveWindow wnd.Visible = False MsgBox "It's Gone" wnd.Visible = True MsgBox "It's Back" It sets an object (wnd) to the active window. Now I can reference that window directly without having to know it's name... -- HTH... Jim Thomlinson "Gerry O" wrote: I have code in workbook open event that hides the window and just shows the userform that opens up. The code is as follows: Windows("ABS Open2.xls").Visible = False I'd like to replace typing the actual filename with code to use the full path of the file so I can easily use this code in other workbooks but can't seem to get the syntax correct. Would appreciate help with the above or alternates. -- Thanks, Gerry O. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Code For OR-Function Using Cell Property | Excel Discussion (Misc queries) | |||
| Password visible if user selects "view code" | Excel Worksheet Functions | |||
| Viewing Access Code in Windows 2000 | Excel Discussion (Misc queries) | |||
| VBA Code Windows | Excel Discussion (Misc queries) | |||
| Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
Hybrid Mode
