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.
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
