LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Windows Visible Property - Code Help

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Code For OR-Function Using Cell Property kylie Excel Discussion (Misc queries) 1 June 20th 06 02:42 AM
Password visible if user selects "view code" kcdonaldson Excel Worksheet Functions 2 December 3rd 05 03:48 PM
Viewing Access Code in Windows 2000 Larry Bird Excel Discussion (Misc queries) 1 November 8th 05 06:23 PM
VBA Code Windows BillCPA Excel Discussion (Misc queries) 2 May 24th 05 04:04 PM
Autoshapes not visible on spreadsheet but visible in print preview John Excel Discussion (Misc queries) 3 February 11th 05 10:23 PM


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"