Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with auto_open
I am trying to use auto_open to create some toolbar buttons and the hide the workbook containing the macros. Everything works fine if I run the workbook from my hard drive or ove a shared drive. The prblem comes if the workbook is opened over the web by clicking o a hyperlink. In this case the workbook does not become invisible for some reason. I've tried hardwiring the window name (from the web) into th window.visible statement - but no luck. Please help - this is driving me nuts ! The code in question: macro_file = "http://server_name/sub_dir/my_macro_file.xls" On Error GoTo not_web Windows(macro_file).Visible = False GoTo the_end not_web: is_visible = Windows("my_macro_file.xls").Visible If (is_visible) Then Windows("my_macro_file.xls").Visible = False the_end -- jmoffa ----------------------------------------------------------------------- jmoffat's Profile: http://www.excelforum.com/member.php...nfo&userid=115 View this thread: http://www.excelforum.com/showthread.php?threadid=26374 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto_open and more.... | New Users to Excel | |||
Auto_open and more.... | New Users to Excel | |||
Auto_open | Excel Discussion (Misc queries) | |||
Help with 'Auto_Open' please... | Excel Discussion (Misc queries) | |||
Beyond AUTO_OPEN | Excel Programming |