View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

Not sure whether there could be a restricted scoll macro in the book ?

Try this quick check/action on a spare copy:

Right-click on the Excel icon just to the left
of "File" on the menu Choose "View Code"
(This will bring you direct into the "ThisWorkbook" module)

In the whitespace on the right, do you see something like:

Private Sub Workbook_Open()
Worksheets("Sheet1").ScrollArea = "b2:b2"
Worksheets("Sheet2").ScrollArea = "c2:c2"
End Sub

If so, delete the lines

Worksheets("Sheet1").ScrollArea = "b2:b2"
Worksheets("Sheet2").ScrollArea = "c2:c2"

then save and exit.

Re-open the book and test it out ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"KangaFrank" wrote in message
...
Essentially, I cannot use the worksheet cell functionality.
I cannot extend cells to Cut & Paste/Copy & Paste data onto another

worksheet
I cannot Autosum because I appear to be locked into an individual cell;

the
Shift+Arrow function does not work.

Your (collective contribution) to a solution is eagerly awaited.

Frank