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 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