Currently I have an Add-In with all of the code to an application that
I have about 30 users accessing randomly throughout the day. I have
password protected the code but the one major problem that I'm having
is that when I need to change the code the Add-In is usaully locked
because another user has accessed the file. Is there a way to prevent
users that are accessing the Add-In from being able to lock the file so
that I can't edit it?
Any help would be greatly appreciated.
Thank you,
James

in the addin' s workbook open event
include a line

If lcase(application.username) < "james geniti" then
thisworkbook.ChangeFileAccess xlReadOnly
end if




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


JGeniti wrote :

Currently I have an Add-In with all of the code to an application that
I have about 30 users accessing randomly throughout the day. I have
password protected the code but the one major problem that I'm having
is that when I need to change the code the Add-In is usaully locked
because another user has accessed the file. Is there a way to prevent
users that are accessing the Add-In from being able to lock the file
so that I can't edit it?
Any help would be greatly appreciated.
Thank you,
James

Thanks, I'll try that.

Just to add to that, to avoid an error you might like to add to that

If lcase(application.username) < "james geniti" _
and not thisworkbook.readonly then
thisworkbook.ChangeFileAccess xlReadOnly
end if

JGeniti wrote:
Thanks, I'll try that.