Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Cursor does not move on protected sheet

I am stumped on this one. I have a workbook with three sheets; one is a
general input screen used to gather specific data relative to a business plan
and is also used to perform calculations on the other two sheets. The second
sheet is used to input job specific information and uses information from the
first sheet to perform calculations. The final sheet is a repository of the
overall calculations. On the first two sheets, I have used conditional
formats to indicate which fields require input from the user. I have also
protected the sheets and workbook in addition to hiding the third sheet.
Sheet 2 works fine; however, on sheet one, the cursor does not move. I can
manually click to the next field for input, but it is not "obvious" that the
cell is selected. On several occassions, the file has locked up (for hours!)
and I had to CTL+ALT+DEL to start over. The cursor moves just fine on sheet
2. What should I be looking for to resolve this problem?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 533
Default Cursor does not move on protected sheet

Try clicking Window, Unfreeze Panes (if it is available.)

--
Jim
"pseudo_pro" wrote in message
...
I am stumped on this one. I have a workbook with three sheets; one is a
general input screen used to gather specific data relative to a business
plan
and is also used to perform calculations on the other two sheets. The
second
sheet is used to input job specific information and uses information from
the
first sheet to perform calculations. The final sheet is a repository of
the
overall calculations. On the first two sheets, I have used conditional
formats to indicate which fields require input from the user. I have also
protected the sheets and workbook in addition to hiding the third sheet.
Sheet 2 works fine; however, on sheet one, the cursor does not move. I
can
manually click to the next field for input, but it is not "obvious" that
the
cell is selected. On several occassions, the file has locked up (for
hours!)
and I had to CTL+ALT+DEL to start over. The cursor moves just fine on
sheet
2. What should I be looking for to resolve this problem?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Cursor does not move on protected sheet

Freeze panes not selected. I can input into the cell, but the cursor stays
static. I have options set for the cursor to move down, and it does on the
2nd sheet. It is just the first sheet where the cursor remains static.

"Jim Rech" wrote:

Try clicking Window, Unfreeze Panes (if it is available.)

--
Jim
"pseudo_pro" wrote in message
...
I am stumped on this one. I have a workbook with three sheets; one is a
general input screen used to gather specific data relative to a business
plan
and is also used to perform calculations on the other two sheets. The
second
sheet is used to input job specific information and uses information from
the
first sheet to perform calculations. The final sheet is a repository of
the
overall calculations. On the first two sheets, I have used conditional
formats to indicate which fields require input from the user. I have also
protected the sheets and workbook in addition to hiding the third sheet.
Sheet 2 works fine; however, on sheet one, the cursor does not move. I
can
manually click to the next field for input, but it is not "obvious" that
the
cell is selected. On several occassions, the file has locked up (for
hours!)
and I had to CTL+ALT+DEL to start over. The cursor moves just fine on
sheet
2. What should I be looking for to resolve this problem?




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 533
Default Cursor does not move on protected sheet

Puzzler. I'd be happy to look at it, fwiw. Clear all the data/formulas of
proprietary stuff if you want, as long as the problem remains.

--
Jim
"pseudo_pro" wrote in message
...
| Freeze panes not selected. I can input into the cell, but the cursor
stays
| static. I have options set for the cursor to move down, and it does on
the
| 2nd sheet. It is just the first sheet where the cursor remains static.
|
| "Jim Rech" wrote:
|
| Try clicking Window, Unfreeze Panes (if it is available.)
|
| --
| Jim
| "pseudo_pro" wrote in message
| ...
| I am stumped on this one. I have a workbook with three sheets; one is
a
| general input screen used to gather specific data relative to a
business
| plan
| and is also used to perform calculations on the other two sheets. The
| second
| sheet is used to input job specific information and uses information
from
| the
| first sheet to perform calculations. The final sheet is a repository
of
| the
| overall calculations. On the first two sheets, I have used
conditional
| formats to indicate which fields require input from the user. I have
also
| protected the sheets and workbook in addition to hiding the third
sheet.
| Sheet 2 works fine; however, on sheet one, the cursor does not move.
I
| can
| manually click to the next field for input, but it is not "obvious"
that
| the
| cell is selected. On several occassions, the file has locked up (for
| hours!)
| and I had to CTL+ALT+DEL to start over. The cursor moves just fine on
| sheet
| 2. What should I be looking for to resolve this problem?
|
|
|
|


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Cursor does not move on protected sheet

Appreciate the reply, but I'll work on it a little longer. It ONLY behaves
this way when protection is turned on and only on this one sheet.

"Jim Rech" wrote:

Puzzler. I'd be happy to look at it, fwiw. Clear all the data/formulas of
proprietary stuff if you want, as long as the problem remains.

--
Jim
"pseudo_pro" wrote in message
...
| Freeze panes not selected. I can input into the cell, but the cursor
stays
| static. I have options set for the cursor to move down, and it does on
the
| 2nd sheet. It is just the first sheet where the cursor remains static.
|
| "Jim Rech" wrote:
|
| Try clicking Window, Unfreeze Panes (if it is available.)
|
| --
| Jim
| "pseudo_pro" wrote in message
| ...
| I am stumped on this one. I have a workbook with three sheets; one is
a
| general input screen used to gather specific data relative to a
business
| plan
| and is also used to perform calculations on the other two sheets. The
| second
| sheet is used to input job specific information and uses information
from
| the
| first sheet to perform calculations. The final sheet is a repository
of
| the
| overall calculations. On the first two sheets, I have used
conditional
| formats to indicate which fields require input from the user. I have
also
| protected the sheets and workbook in addition to hiding the third
sheet.
| Sheet 2 works fine; however, on sheet one, the cursor does not move.
I
| can
| manually click to the next field for input, but it is not "obvious"
that
| the
| cell is selected. On several occassions, the file has locked up (for
| hours!)
| and I had to CTL+ALT+DEL to start over. The cursor moves just fine on
| sheet
| 2. What should I be looking for to resolve this problem?
|
|
|
|





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Cursor does not move on protected sheet

What I have found that I think will work is to write a macro which will
control the movement of the cursor. I am not very strong in macro writing,
so any help would be appreciated.
There are two sheets that require input from the user. The first is a
PROFILE sheet which asks the user to input specific information relative to
their business plan. Once input, it does not need to be changed unless
something changes in the business. (This is the sheet that is NOT allowing
cursor movement at the moment and hence the need for a macro.)

Here are the cells in order of their needed input:
PROFILE!C3
PROFILE!C4
PROFILE!C5
PROFILE!C9
PROFILE!C10
PROFILE!C11
PROFILE!C12
PROFILE!C13
PROFILE!C14
PROFILE!C18
PROFILE!C19
PROFILE!C20
PROFILE!C28
PROFILE!C29
PROFILE!C33
PROFILE!F3
PROFILE!F5
PROFILE!F11
PROFILE!F12
PROFILE!F14 (this field is a drop down using validation)
PROFILE!F15
PROFILE!F20
PROFILE!F29

Ideally, I would also like a prompt to save in this macro as well.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cursor does not move on one sheet in protected workbook pseudo_pro Excel Worksheet Functions 2 December 13th 07 07:24 PM
move cursor on one sheet moves cursor on all sheets tdworden Excel Discussion (Misc queries) 2 July 22nd 07 10:50 PM
Down arrow moves cursor to top of worksheet when sheet protected Bill Williams Excel Worksheet Functions 0 April 29th 06 06:37 PM
Move cursor through all unprotected cells in a protected worksheet Bob Simpson Excel Discussion (Misc queries) 9 November 18th 05 06:50 PM
In a protected sheet how do I get the cursor to only move to unlo. PapaBear Excel Discussion (Misc queries) 2 April 22nd 05 09:32 PM


All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"