Add-in Installation in a Network Environment

Fowmy

Well-known Member
Joined
Jul 10, 2008
Messages
516
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have placed an Add-in in a network drive and installed in each workstation all using Excel 2007 without copying it to the local Addin folder in order for everyone to access the same Addin as read-only except myself who is allowed to make changes and save. I have set-up the Workbook_Open event of the Addin to do it for me but, When I start Excel, I am supposed to have full access, instead, it opens as read-only with the message "MyAddin.xlam is locked for editing by another user" with Notify and Cancel buttons. I checked all the workstations and confirmed that the addin is opened as read-only. My question is why doesn't the file open with full access in my machine while everyone else has it opened read-only?

Appreciate, your repose and suggestion.

Code:
  If Application.UserName <> "xxxx" Then
        If Not MyAddin.ReadOnly Then
            Call MyAddin.ChangeFileAccess xlReadOnly
        End If
  Else       
        If MyAddin.ReadOnly Then
            MyAddin.Saved = True
            MyAddin.ChangeFileAccess xlReadWrite
        End If
  End If
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
You shouldn't get the Notify message if the Add-In is installed via Excel Options|Add-Ins|Manage. You may get it if you use File|Open to open the Add-In.
 
Upvote 0
Thanks for your reply Andrew,

I did install the addin through excel Options as you mentioned but it still opens as read-only.
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top