Login needed for open workbook and then run some VBA
Hello,
I have a spreadsheet that I need input from different gorup of people but one group shold only modify their own data (cetain cells). And whe one group is done, he save it and allow next group to update thei part. Workbook is save in the public folder. So here is what I want t do: Group 1 log in, at this time it will unprotect group1's data, bu protect the rest. Once group1 is done, it save and protect everythin again. Next group come and login and then start all these again. While one group logged in, the other group can not log in. The reason for login at the begining is that if someone already logge in, other group can not... Is all these possible? And help is very appreciated. Any suggestion an code are also welcomed! Thanks in advance. -Steve -- Message posted from http://www.ExcelForum.com |
Login needed for open workbook and then run some VBA
|
All times are GMT +1. The time now is 04:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com