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: 2
Default How to see if the opened workbook is opened by another user ?

Hi,

I want to restrict the use of an Excel application to just one user at
a time. Basically, my application is composed of a few protected
sheets (user must not change the cells manually), and a toolbar with
macros associated.

I only want 1 user to be able to have to execute macros at the same
time. I would like to gray all the toolbar's buttons when the excel
file is already opened by another user.

Now, how can I detect that the excel file is already opened by another
user with vba code ?

Thank you for your help in advance,


Alex
 
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
formula not working when opened by another user K Excel Discussion (Misc queries) 0 October 27th 08 03:18 PM
Need to Query Excel File Opened by Another User Paul Excel Discussion (Misc queries) 0 December 13th 06 05:57 PM
Shared spreadsheet changes color when opened ny another user. Why Nick DeSimone Excel Worksheet Functions 0 May 26th 06 05:13 PM
Shared spreadsheet changes color when opened ny another user. Why Nick DeSimone Excel Worksheet Functions 0 May 26th 06 05:12 PM
Spreadsheet opened by user or programme Jenni[_2_] Excel Programming 4 November 3rd 03 06:44 AM


All times are GMT +1. The time now is 07:11 AM.

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"