View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dragontale dragontale is offline
external usenet poster
 
Posts: 1
Default 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