record level locking in excel spreadsheets using macros??

ajas

New Member
Joined
Nov 16, 2005
Messages
2
Can a spreadsheet be designed, possibly with macros, that “senses” the IDSID of the user (mine would be “ajas). A user could modify or delete ONLY those lines of the spreadsheet he/she created. And anyone can create new lines. New lines are always tagged with the IDSID of the creator (not an option, not an editable field). Any one can view everyone else’s stuff, but only edit their own. Maybe “gray out” everyone else’s data to make the distinction visible.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
I imagine it could be done. However, XL is not designed for such work. Consequently, the amount of programming needed to build a foolproof system would be horrendous. You will be better off exploring real databases such as MS Access or its various competitors.
 

ajas

New Member
Joined
Nov 16, 2005
Messages
2
Wouldn't the whole file get locked?

Thanks for your reply Tushar!
However,Its my understanding, and I might be wrong since I have no experience with Excel programming, that whenever one person has opened an excel file, sombody else cannot open it and edit it after him because the OS locks the file for editing. It then is displayed as a Read-Only file as long as the first person is working on it. So, if I have people doing stuff simultaneously, record-level locking is out of the question. Even before it goes to that stage , working according to macros, the OS would lock the file for editing. Am I right?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,673
Messages
5,573,588
Members
412,537
Latest member
Mohamed_5966
Top