View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default Open Referenced Add In Workbook as Read Only

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