Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default limited cell movement

I cannot move my cursor on one of my worksheets to any cell outside of the
range of A1:N125. There are locked cells within this range that are blocked
once the sheet is protected, but I can access them properly by turning the
protection off. However, I still cannot move to any cell outside of the
aforementioned range. Is there another setting that I am missing somewhere?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,071
Default limited cell movement

Look in the sheet module and in the ThisWorkbook module for some code that
limits the scroll range in that one sheet. Delete that piece of code if you
wish. HTH Otto

"thebusinessbus" wrote in message
...
I cannot move my cursor on one of my worksheets to any cell outside of the
range of A1:N125. There are locked cells within this range that are
blocked
once the sheet is protected, but I can access them properly by turning the
protection off. However, I still cannot move to any cell outside of the
aforementioned range. Is there another setting that I am missing
somewhere?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default limited cell movement

Hi,
you have been limited to that range do this, right click on the mouse, view
code,on the left you will see properties, look into Scrollarea almost at the
end, clear the field at the right

"thebusinessbus" wrote:

I cannot move my cursor on one of my worksheets to any cell outside of the
range of A1:N125. There are locked cells within this range that are blocked
once the sheet is protected, but I can access them properly by turning the
protection off. However, I still cannot move to any cell outside of the
aforementioned range. Is there another setting that I am missing somewhere?

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 movement to last cell with same number Steven Excel Discussion (Misc queries) 5 October 8th 09 04:39 PM
Cell to cell movement with arrow keys moves entire sheet ken heinemann Excel Worksheet Functions 1 December 29th 06 12:30 AM
Tab Key Expanded Cell Movement DennisLeary Excel Discussion (Misc queries) 2 April 8th 06 03:05 AM
How can I control cell movement with the Tab key? Bojo Excel Discussion (Misc queries) 4 September 3rd 05 01:16 AM
Force Cell Movement Jasmine Excel Discussion (Misc queries) 1 March 19th 05 12:06 AM


All times are GMT +1. The time now is 09:50 PM.

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"