Open Referenced Add-In Worked as Read Only

R

Ryan H

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

Peter T

wb.SaveAs Filename:="<path>myAddin.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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Referenced Add In Workbook as Read Only 5
Open Add-In (.xla) workbook as Read Only automatically 1
Close Referenced Workbook if it's No Longer Referenced 4
How does Excel Know Where a Referenced Add-In Wbk is Located 1
Why is Add-In (.xla) Workbook Read Only when I try to save? 1
VBA referencing disappears with 2007 upgrade 1
VSTO: Detecting Read Only status of workbook opened from Sharepoin 3
VSTO-Detecting Read Only status of workbook opened from Sharepoint 2

Top