LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default How to prevent multi-access for XLAs?

When Excel opens a workbook, it checks whether it is currently already open,
and in this case opens the workbook in read-only mode. This is good as it
prevents writing conflicts.

However I noticed that Excel won't check that lock, when the file is an
Addin. This is understandable since an Addin is supposed to Add functionality
to Excel, not store data, so that there is no need to handle concurrent
access.

However the Addin I made stores user data and I would like to have Excel to
warn the user that the Addin is in use, whenever someone else has opened it.

Is there a way to have that same warning Excel issues for workbooks, when an
addin is opened by a second user?
--
Stefano Gatto
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL ONLINE MULTI ACCESS Dave F Excel Discussion (Misc queries) 1 September 25th 06 11:56 AM
add-in manager just for XLAs? [email protected] Excel Discussion (Misc queries) 3 August 14th 06 01:24 PM
Multi users and linking to Access Ray Excel Discussion (Misc queries) 0 September 20th 05 03:15 AM
Software for Distribution of XLAs ExcelMonkey Excel Programming 2 September 15th 05 09:28 PM
Restricting Multi-user access [email protected] Excel Worksheet Functions 0 June 17th 05 03:03 PM


All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"