Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel Shared Workbook - VBA issue
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel Shared Workbook - VBA issue
Resolved · Urgent Priority · Version 2003
Reply Wed 18 Jan 2012, 10:32Delegate Sharon said...
Sharon has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Excel Shared Workbook - VBA issue
Hello,
I have created a shared workbook which allows users to enter data through a user form and then run reports based on that data.
There are about 20 users who update information at the same time and I have made sure that each person has their own allocated data tab so I don't get any save changes issues.
To prevent any corruption, I would like to know if there is any code to count the number of users in a file and if there are already say 10 people in the file, a message box will appear to say that they can't update at the moment and to try again in 5 mins.
Is this possible?
Thank you,
Sharon.
For upcoming training course dates see: Pricing & availability
RE: Excel Shared Workbook - VBA issue
Hello Sharon
Thank you for your post, it has taken us longer to get back to you as a few of us have had a review.
Our thoughts are that most likely we can find a solution for you but it is beyond the scope of this forum. Your type of request falls more into consultancy area as we would need to have a look at your working files.
If a solution presents itself we will advise you on how much trainer development time will be required and associated costs.
Should you wish to progress this please do reply to my email.
Kind regards
Jacob
Tue 31 Jan 2012: Automatically marked as resolved.
|