Move cursor through all unprotected cells in a protected worksheet
 

I have Excel 2003 at home and have completed a protected worksheet with a
number of unprotected cells for data entry. The cursor skips thru each
unprotected cell without trawling thru the rest of the worksheet. When I
copy this onto another computer at work, the cursor moves through EVERY cell,
although it will display a message if I try to enter anything in a protected
cell. What is set on my computer at home that is not set on the works
computer? (I am using the ENTER key, not the tab or anything). Any
pointers would be appreciated

Move cursor through all unprotected cells in a protected worksheet
 

Hi Bob,
I expect you meant skips each protected cell at home (it works),
and of course we know it does not work at work.

At work you forgot to protect the sheet. Tools, protection, protect sheet
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Simpson" <Bob wrote in message ...
I have Excel 2003 at home and have completed a protected worksheet with a
number of unprotected cells for data entry. The cursor skips thru each
unprotected cell without trawling thru the rest of the worksheet. When I
copy this onto another computer at work, the cursor moves through EVERY cell,
although it will display a message if I try to enter anything in a protected
cell. What is set on my computer at home that is not set on the works
computer? (I am using the ENTER key, not the tab or anything). Any
pointers would be appreciated

Move cursor through all unprotected cells in a protected worksheet
 

or
How many woodchucks could a woodchuck Chuck If a woodchuck could Chuckwood?

--
Don Guillett
SalesAid Software

"David McRitchie" wrote in message
...
Hi Bob,
I expect you meant skips each protected cell at home (it works),
and of course we know it does not work at work.

At work you forgot to protect the sheet. Tools, protection, protect
sheet
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Simpson" <Bob wrote in message
...
I have Excel 2003 at home and have completed a protected worksheet with a
number of unprotected cells for data entry. The cursor skips thru each
unprotected cell without trawling thru the rest of the worksheet. When
I
copy this onto another computer at work, the cursor moves through EVERY
cell,
although it will display a message if I try to enter anything in a
protected
cell. What is set on my computer at home that is not set on the works
computer? (I am using the ENTER key, not the tab or anything). Any
pointers would be appreciated

Move cursor through all unprotected cells in a protected worksheet
 

Bob

Make sure when you protect the sheet that you de-select "select locked cells".

This should allow your ENTER key to jump to unlocked cells only.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 06:25:21 -0800, "Bob Simpson" <Bob
wrote:

I have Excel 2003 at home and have completed a protected worksheet with a
number of unprotected cells for data entry. The cursor skips thru each
unprotected cell without trawling thru the rest of the worksheet. When I
copy this onto another computer at work, the cursor moves through EVERY cell,
although it will display a message if I try to enter anything in a protected
cell. What is set on my computer at home that is not set on the works
computer? (I am using the ENTER key, not the tab or anything). Any
pointers would be appreciated

Move cursor through all unprotected cells in a protected works
 

Thanks Gord - your reply makes sense - I will check tomorrow - presumably
copying the file does not also copy over this instruction. David's
presumption that I have not protected the sheet cannot be correct because
when the cursor moves to a protected cell, a message tells me I can't write
to it. As for Don Guillett woodchuck his reply in the bin.

Thanks again
Bob Simpson

"Gord Dibben" wrote:

Bob

Make sure when you protect the sheet that you de-select "select locked cells".

This should allow your ENTER key to jump to unlocked cells only.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 06:25:21 -0800, "Bob Simpson" <Bob
wrote:

I have Excel 2003 at home and have completed a protected worksheet with a
number of unprotected cells for data entry. The cursor skips thru each
unprotected cell without trawling thru the rest of the worksheet. When I
copy this onto another computer at work, the cursor moves through EVERY cell,
although it will display a message if I try to enter anything in a protected
cell. What is set on my computer at home that is not set on the works
computer? (I am using the ENTER key, not the tab or anything). Any
pointers would be appreciated

Move cursor through all unprotected cells in a protected works
 

Bob

I have noticed that those two options...........select locked cells and select
unlocked cells can be a little flaky at times.

As can Don<g


Gord

On Thu, 17 Nov 2005 11:10:06 -0800, "Bob Simpson"
wrote:

Thanks Gord - your reply makes sense - I will check tomorrow - presumably
copying the file does not also copy over this instruction. David's
presumption that I have not protected the sheet cannot be correct because
when the cursor moves to a protected cell, a message tells me I can't write
to it. As for Don Guillett woodchuck his reply in the bin.

Thanks again
Bob Simpson

"Gord Dibben" wrote:

Bob

Make sure when you protect the sheet that you de-select "select locked cells".

This should allow your ENTER key to jump to unlocked cells only.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 06:25:21 -0800, "Bob Simpson" <Bob
wrote:

I have Excel 2003 at home and have completed a protected worksheet with a
number of unprotected cells for data entry. The cursor skips thru each
unprotected cell without trawling thru the rest of the worksheet. When I
copy this onto another computer at work, the cursor moves through EVERY cell,
although it will display a message if I try to enter anything in a protected
cell. What is set on my computer at home that is not set on the works
computer? (I am using the ENTER key, not the tab or anything). Any
pointers would be appreciated

Move cursor through all unprotected cells in a protected works
 

little flaky at times
moi ???<G I was taken by David's

I expect you meant skips each protected cell at home (it works),
and of course we know it does not work at work.

and couldn't resist

--
Don Guillett
SalesAid Software

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Bob

I have noticed that those two options...........select locked cells and
select
unlocked cells can be a little flaky at times.

As can Don<g


Gord

On Thu, 17 Nov 2005 11:10:06 -0800, "Bob Simpson"
wrote:

Thanks Gord - your reply makes sense - I will check tomorrow - presumably
copying the file does not also copy over this instruction. David's
presumption that I have not protected the sheet cannot be correct because
when the cursor moves to a protected cell, a message tells me I can't
write
to it. As for Don Guillett woodchuck his reply in the bin.

Thanks again
Bob Simpson

"Gord Dibben" wrote:

Bob

Make sure when you protect the sheet that you de-select "select locked
cells".

This should allow your ENTER key to jump to unlocked cells only.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 06:25:21 -0800, "Bob Simpson" <Bob
wrote:

I have Excel 2003 at home and have completed a protected worksheet with
a
number of unprotected cells for data entry. The cursor skips thru
each
unprotected cell without trawling thru the rest of the worksheet.
When I
copy this onto another computer at work, the cursor moves through EVERY
cell,
although it will display a message if I try to enter anything in a
protected
cell. What is set on my computer at home that is not set on the works
computer? (I am using the ENTER key, not the tab or anything). Any
pointers would be appreciated

Move cursor through all unprotected cells in a protected works
 

Hi Gord - the saga continues...... I find that on putting protection on the
pc at work I only get a choice of protecting Contents, Objects and Scenarios
- whatever they are! I hadn't realised Its totally different to the
selection box on mine and I presume this is an old version of Excel but as
you seem to be an expert I wondered if I can still find a way round this or
do I have to get them to update the sprreadsheet?

I realise you may not now see this message but thought it worth a try

Thanks for your help anyway
Bob

"Gord Dibben" wrote:

Bob

I have noticed that those two options...........select locked cells and select
unlocked cells can be a little flaky at times.

As can Don<g


Gord

On Thu, 17 Nov 2005 11:10:06 -0800, "Bob Simpson"
wrote:

Thanks Gord - your reply makes sense - I will check tomorrow - presumably
copying the file does not also copy over this instruction. David's
presumption that I have not protected the sheet cannot be correct because
when the cursor moves to a protected cell, a message tells me I can't write
to it. As for Don Guillett woodchuck his reply in the bin.

Thanks again
Bob Simpson

"Gord Dibben" wrote:

Bob

Make sure when you protect the sheet that you de-select "select locked cells".

This should allow your ENTER key to jump to unlocked cells only.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 06:25:21 -0800, "Bob Simpson" <Bob
wrote:

I have Excel 2003 at home and have completed a protected worksheet with a
number of unprotected cells for data entry. The cursor skips thru each
unprotected cell without trawling thru the rest of the worksheet. When I
copy this onto another computer at work, the cursor moves through EVERY cell,
although it will display a message if I try to enter anything in a protected
cell. What is set on my computer at home that is not set on the works
computer? (I am using the ENTER key, not the tab or anything). Any
pointers would be appreciated

Move cursor through all unprotected cells in a protected works
 

Bob

Yes, sounds like it is an older version of Excel(Pre-2002 version) and the
ENTER key will not jump to unlocked cells only.

The only workaround would be to use the Tab key to move through unlocked
cells.

Or a named range.

See Bob Phillips' site for more on this.

http://www.xldynamic.com/source/xld.xlFAQ0008.html


Gord

On Fri, 18 Nov 2005 08:26:25 -0800, "Bob Simpson"
wrote:

Hi Gord - the saga continues...... I find that on putting protection on the
pc at work I only get a choice of protecting Contents, Objects and Scenarios
- whatever they are! I hadn't realised Its totally different to the
selection box on mine and I presume this is an old version of Excel but as
you seem to be an expert I wondered if I can still find a way round this or
do I have to get them to update the sprreadsheet?

I realise you may not now see this message but thought it worth a try

Thanks for your help anyway
Bob

"Gord Dibben" wrote:

Bob

I have noticed that those two options...........select locked cells and select
unlocked cells can be a little flaky at times.

As can Don<g


Gord

On Thu, 17 Nov 2005 11:10:06 -0800, "Bob Simpson"
wrote:

Thanks Gord - your reply makes sense - I will check tomorrow - presumably
copying the file does not also copy over this instruction. David's
presumption that I have not protected the sheet cannot be correct because
when the cursor moves to a protected cell, a message tells me I can't write
to it. As for Don Guillett woodchuck his reply in the bin.

Thanks again
Bob Simpson

"Gord Dibben" wrote:

Bob

Make sure when you protect the sheet that you de-select "select locked cells".

This should allow your ENTER key to jump to unlocked cells only.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 06:25:21 -0800, "Bob Simpson" <Bob
wrote:

I have Excel 2003 at home and have completed a protected worksheet with a
number of unprotected cells for data entry. The cursor skips thru each
unprotected cell without trawling thru the rest of the worksheet. When I
copy this onto another computer at work, the cursor moves through EVERY cell,
although it will display a message if I try to enter anything in a protected
cell. What is set on my computer at home that is not set on the works
computer? (I am using the ENTER key, not the tab or anything). Any
pointers would be appreciated

Move cursor through all unprotected cells in a protected works
 

Thanks for your time on this Gord - at least I know what the problem is now
and a quick look at the site suggests I will manage with TAB. Really
appreciate it

Bob

"Gord Dibben" wrote:

Bob

Yes, sounds like it is an older version of Excel(Pre-2002 version) and the
ENTER key will not jump to unlocked cells only.

The only workaround would be to use the Tab key to move through unlocked
cells.

Or a named range.

See Bob Phillips' site for more on this.

http://www.xldynamic.com/source/xld.xlFAQ0008.html


Gord

On Fri, 18 Nov 2005 08:26:25 -0800, "Bob Simpson"
wrote:

Hi Gord - the saga continues...... I find that on putting protection on the
pc at work I only get a choice of protecting Contents, Objects and Scenarios
- whatever they are! I hadn't realised Its totally different to the
selection box on mine and I presume this is an old version of Excel but as
you seem to be an expert I wondered if I can still find a way round this or
do I have to get them to update the sprreadsheet?

I realise you may not now see this message but thought it worth a try

Thanks for your help anyway
Bob

"Gord Dibben" wrote:

Bob

I have noticed that those two options...........select locked cells and select
unlocked cells can be a little flaky at times.

As can Don<g


Gord

On Thu, 17 Nov 2005 11:10:06 -0800, "Bob Simpson"
wrote:

Thanks Gord - your reply makes sense - I will check tomorrow - presumably
copying the file does not also copy over this instruction. David's
presumption that I have not protected the sheet cannot be correct because
when the cursor moves to a protected cell, a message tells me I can't write
to it. As for Don Guillett woodchuck his reply in the bin.

Thanks again
Bob Simpson

"Gord Dibben" wrote:

Bob

Make sure when you protect the sheet that you de-select "select locked cells".

This should allow your ENTER key to jump to unlocked cells only.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 06:25:21 -0800, "Bob Simpson" <Bob
wrote:

I have Excel 2003 at home and have completed a protected worksheet with a
number of unprotected cells for data entry. The cursor skips thru each
unprotected cell without trawling thru the rest of the worksheet. When I
copy this onto another computer at work, the cursor moves through EVERY cell,
although it will display a message if I try to enter anything in a protected
cell. What is set on my computer at home that is not set on the works
computer? (I am using the ENTER key, not the tab or anything). Any
pointers would be appreciated