View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default excel limit data entry range, control cursor movement to 2 cols

You can limit the scroll area. In the VBE select the sheet you want to limit
and then in the properties set the scroll area to the two columns you want...
--
HTH...

Jim Thomlinson


"Bob" wrote:

control cursor movement to 2 columns, left to right, jump to line 2. Able to
protect columns to right, but cursor jumps to column 3.