If your clients can see the add-in when it opens, then it isn't really an
addin because it would open invisibly behind the scenes and only be available
to the ordinary client through the VBE.
I would suggest that you put something like the following in the 'Quote.xls'
workbook's ThisWorkbook Workbook_Open() module to make your add-in a true
add-in...

Private Sub Workbook_Open()
'Assuming the 'My Add-In' is in the TITLE field
' of the add-in's properties
Workbooks.Open Filename:="C:\Temp\MyAddin.xla"
AddIns("My Add-in").Installed = True
End Sub

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Ryan H" wrote:

I have a Quote workbook (.xls) that refrences code in an Add-In workbook
(.xla). Is there a way to have the Add-In workbook automatically open as
Read Only? I saved the Add-In with a password to modify and when the Add-In
is opened the user is asked to enter a password or click Read Only button.
I'd like to skip this dialog box.

By doing this I should be able to overwrite the Add-In workbook to update
"bugs" that I find, without having everyone on the sales team close the
workbooks so I can do updates.

Thanks in Advance!
--
Cheers,
Ryan