Hi, I have an Excel 2010 Workbook with 17 Worksheets, Sheet1... Sheet17. I have this workbook shared on the network. Employees open this workbook and they enter their daily work log into it individual work sheets. The problem I am having is that "No one knows who did it" syndrome where either accidently or intentionally employees are subtracting the work done by other employees or deleting data.
So I am looking for a solution where I can restrict each employee to their own worksheet. All suggestions are welcome. I came across the following code this works great for sheet1 but I need it to be modified for 17 sheets. As I am not a programmer I have not been able to implement it across my 17 sheets. Can you guys fix it so that I can use it across my 17 sheets. This is the code: http://www.ozgrid.com/VBA/stop-worksheet-viewing.htm thanks to all -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
