Open Referenced Add-In Worked as Read Only
 

I have Workbook A that references code in Workbook B that is saved as an
add-in. Both workbooks are saved on our server. When the user opens
Workbook A, Workbook B opens automatically in the back ground because it is
saved as an add-in. Is there a way to have Workbook B open as Read-Only
automatically? This would help me, because sometimes I need to debug the
add-in and save changes. If any of the sales people are using the workbook B
then I can't save it to the orginal file, because it is read only. Any ideas?
--
Cheers,
Ryan

Open Referenced Add-In Worked as Read Only
 

wb.SaveAs Filename:="<pathmyAddin.xla", ReadOnlyRecommended:=True

When you programmatically open it you'll probably want to temporarily
DisplayAlerts

Anyone could of course save a copy of the file.

Regards,
Peter T


"Ryan H" wrote in message
...
I have Workbook A that references code in Workbook B that is saved as an
add-in. Both workbooks are saved on our server. When the user opens
Workbook A, Workbook B opens automatically in the back ground because it
is
saved as an add-in. Is there a way to have Workbook B open as Read-Only
automatically? This would help me, because sometimes I need to debug the
add-in and save changes. If any of the sales people are using the
workbook B
then I can't save it to the orginal file, because it is read only. Any
ideas?
--
Cheers,
Ryan