Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2007: line chart lines disappear when referenced workbook is not open | Charts and Charting in Excel | |||
Axis labels problem when referenced workbook not open... | Charts and Charting in Excel | |||
Shared worked very slow to open | Excel Discussion (Misc queries) | |||
Sumif Error when Referenced Wkbk not open | Excel Discussion (Misc queries) | |||
is it always necessary to open workbooks referenced in a formula | Excel Discussion (Misc queries) |