That what they have now ...without the macro to combine them and they have to roll it up by hand. Can I use the Macro recorder in Excel to do this task?
On Nov 10, 2:15 pm, "dguillett1" <dguille...@gmail.com> wrote: > Why not give each their own sheet and then you combine with a macro. > > Don Guillett > SalesAid Software > dguille...@gmail.com > > > > -----Original Message----- > From: Dave > Sent: Thursday, November 10, 2011 2:09 PM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Modify code to lock multiple sheets in a > spreadsheet. > > 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- Hide > quoted text - > > - Show quoted text - -- 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
