Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

2010-03-18 Thread Paul Schreiner
e: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior On Mar 17, 11:57 am, Paul Schreiner wrote: > Can you send me the file? No, sorry I can't.  It's got confidential info.  So, stupid question, but just wanna make sure ... with Locking checked and She

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

2010-03-17 Thread Jeff
On Mar 17, 11:57 am, Paul Schreiner wrote: > Can you send me the file? No, sorry I can't. It's got confidential info. So, stupid question, but just wanna make sure ... with Locking checked and Sheet Protection on, those cells should definitely not be accepting user input, right? --

RE: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

2010-03-17 Thread Dave Bonallack
Mar 2010 06:52:07 -0700 > Subject: Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell > locking behavior > From: jeffhollifield1...@gmail.com > To: excel-macros@googlegroups.com > > I don't think my question was clear. I understand how to lock or > unlock cells.

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

2010-03-17 Thread Paul Schreiner
, March 17, 2010 9:52:07 AM Subject: Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior I don't think my question was clear.  I understand how to lock or unlock cells.  The problem I'm having isn't with this.  What I'm seeing is that when the Worksheet P

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

2010-03-17 Thread Jeff
x27; thing once. > > Regards - Dave. > > > > > Date: Tue, 16 Mar 2010 10:35:15 -0700 > > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking > > behavior > > From: jeffhollifield1...@gmail.com > > To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

2010-03-17 Thread rf1234 rf1234
> Regards - Dave. > > > Date: Tue, 16 Mar 2010 10:35:15 -0700 > > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell > locking behavior > > From: jeffhollifield1...@gmail.com > > To: excel-macros@googlegroups.com > > > > > Hi all, &g

RE: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

2010-03-16 Thread Dave Bonallack
l key, and just do the 'Locked' thing once. Regards - Dave. > Date: Tue, 16 Mar 2010 10:35:15 -0700 > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking > behavior > From: jeffhollifield1...@gmail.com > To: excel-macros@googlegroups.com

$$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

2010-03-16 Thread Jeff
Hi all, I've got an Excel spreadsheet that is used for collecting some data from end users and each tab uses Sheet Protection with a password, with users able to select locked & unlocked cells. We also have a mix of locked & unlocked cells on each tab. There's also no VBA in this workbook. On o