Read only and hide

[coreydunn]

I am creating a macro for excel in VB and it isnt working correctly. When workbook A is opened it needs to open workbook B as read only and then hide it... it is used to hold the macros for all users.

Here is what I have:

--------------------------
Sub OpenNoShowReadOnly()
Workbooks.Open "J:\Collections\High Usage\HUT WorkFolder\RawData\Macro.xls" = ReadOnly
Windows("Macro.xls").Visible = False
End Sub
---------------------------

 

[PHV]

Perhaps this ?
Workbooks.Open "J:\Collections\High Usage\HUT WorkFolder\RawData\Macro.xls" ReadOnly:=True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sahmiele]

Use the code below in File A. This will automatically open file B and hide it when File A is opened.


Sub Auto_open()
Workbooks.Open "J:\Collections\High Usage\HUT WorkFolder\RawData\Macro.xls" = ReadOnly
Windows("Macro.xls").Visible = False




End Sub