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

Read Only now different 1
Open Referenced Add In Workbook as Read Only 5
Name of file opened, being viewed 2
Sub projects added as read only in Master file which are saved on sharepoint 1
Open Add-In (.xla) workbook as Read Only automatically 1
Close Referenced Workbook if it's No Longer Referenced 4
VSTO C# add in Outlook.Appointment error 0
User can't share a PowerPoint deck - "only document owners can share their documents" 0

Top