LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 90
Default This seems weird to me

G'day there Peoples,

Whilst investigating my scrolling troubles (outlined in another
post), I took the following actions.

Created a new blank workbook. Removed all AddIns. Selected Row 10,
on first sheet and then down to bottom of sheet. Set selected cells
protection to "Unlocked". I then protected the sheet, ticking only
"Select Unlocked Cells". That way I should have been able to select all
cells in rows below 9.

I had the cursor in some random cell in about row 14, column 5 or
6, and then I pressed the down arrow. The selected cell immediately
jumped to column 1, row 10 (top, left unlocked cell) and refused to move
no matter which arrow key I pressed.

Is this normal? What changes with regard to scrolling when a
worksheet is protected? I have no idea of whether this is something I
can resolve, or whether I just have to leave the whole thing
unprotected. That's not a real good option.

Does anyone know how this is supposed to work?

See ya
Ken McLennan
Qld, Australia
 
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
Is this weird or what? Finance Guru Excel Worksheet Functions 8 August 15th 08 07:24 PM
Very weird error Stian Excel Worksheet Functions 4 November 21st 05 10:50 PM
Weird jhill New Users to Excel 1 August 10th 05 04:48 PM
weird LiSa Excel Programming 2 June 10th 04 09:37 AM
Weird VBA problem Bob[_55_] Excel Programming 3 May 12th 04 11:39 PM


All times are GMT +1. The time now is 02:41 AM.

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

About Us

"It's about Microsoft Excel"