Re: $$Excel-Macros$$ Modify code to lock multiple sheets in a spreadsheet.

2011-11-11 Thread rajan verma
mbine the files, if desired. > > > > > Don Guillett > SalesAid Software > dguille...@gmail.com > -Original Message- From: Dave > Sent: Thursday, November 10, 2011 2:18 PM > > To: MS EXCEL AND VBA MACROS > Subject: Re: $$Excel-Macros$$ Modify code to lock m

Re: $$Excel-Macros$$ Modify code to lock multiple sheets in a spreadsheet.

2011-11-10 Thread dguillett1
: Thursday, November 10, 2011 2:18 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Modify code to lock multiple sheets in a spreadsheet. 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

Re: $$Excel-Macros$$ Modify code to lock multiple sheets in a spreadsheet.

2011-11-10 Thread Dave
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. > >

Re: $$Excel-Macros$$ Modify code to lock multiple sheets in a spreadsheet.

2011-11-10 Thread dguillett1
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

$$Excel-Macros$$ Modify code to lock multiple sheets in a spreadsheet.

2011-11-10 Thread Dave
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 acci