: When I code  the following in Workbook_open() of ThisWorkbook to limit
: the col/rows that a user  can access:
:
: sheet1.ScrollArea = "a1:z100"
:
: It works  as expected.
:
: But then, I found  that I was not allowed  to click/drag on the row
: header  to highlight  the entire  row(or rows). If I comment  the above
: code out, I could click/drag row  headers again.
:
: Does this sound  right? Why does ScrollArea have anything to do
: with clicking/draging row headers?

According to VBA Help, "Cells outside the scroll area cannot be
selected." Selecting an entire row would attempt to do that.


: How can I both limiting the col/rows that a user can access  and
: allowing a user to click/drag on the row headers to highlight the
: entire row(s)?

I don't know that you can.

If you have nothing to the right of col Z that you want protected, you could
make it
sheet1.ScrollArea = "A1:IV100"