I think I'd use a helper workbook that opened the workbook with the list first
(as readonly). Then opened the real workbook.
Then I wouldn't have to worry about users not answering the prompts correctly --
to update links and to open the workbook readonly.
Option Explicit
Sub auto_open()
Workbooks.Open Filename:="\\path\path\path\bookwithlist.xls", _
UpdateLinks:=1, Password:="hithere", readonly:=true
Workbooks.Open Filename:="\\path\path\path\yourrealworkbookhere.x ls", _
Password:="hithere"
ThisWorkbook.Close savechanges:=False
End Sub
You could give each workbook a password to open. Then the users would have to
use the helper workbook to open each (don't share the passwords).
And save that first workbook with all its windows hidden so that it won't even
be noticed.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
SShetty wrote:
I am trying to set up validation from a list on another workbook. How do I
make the souce list workbook open everytime I open the Master file. I dont
want other users to see the actual source list.
--
Dave Peterson