Excel columns greyed out

[Seriak]

Please help.

I received a spreadsheet from someone and they have information i
which they somehow greyed out to the left. Now it is not just greye
out becuase you cannot click on the cells or move the cursor into th
grey area at all. You cannot even scoll past the spreadsheet the
setup. They somehow prevented scrolling to the left or right. Th
entire sheet is just the size of the data area.

My question is. How did they do this. The sheet is not protected as
unprotected it so it can't be that function.

Please help.

Chri

 

[Frank Kabel]

Hi
maybe a protection ('Tools - Protection') together with freezing the
panes ('Window - Freeze Panes')

 

[Max]

The scroll area for the sheet might have been restricted
via a macro (placed in the "ThisWorkbook" module), for example:

Private Sub Workbook_Open()
Worksheets("Sheet1").ScrollArea = "a1:d5"
End Sub

One way to go to the "ThisWorkbook" module:

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

 

[Mike A]

you cannot click on the cells or move the cursor into the
grey area at all. You cannot even scoll past the spreadsheet they
setup. They somehow prevented scrolling to the left or right. The
entire sheet is just the size of the data area.

My question is. How did they do this.
Please help.

Chris


---

In the project explorer of the VBE, each sheet has a ScrollArea
property. This has been set to the 'data area' of the worksheet.




Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers

 

[Max]

In the project explorer of the VBE, each sheet has a ScrollArea
property. This has been set to the 'data area' of the worksheet.

Agree, but think the setting doesn't persist ..

Tried setting the ScrollArea property to say "$A$1:$D$5" in Sheet1
Upon saving the book and re-opening, the setting disappeared

So it seems a macro was operative in the OP's case
(An example of which was posted earlier)

 

[Kalabalana]

*
...
panes ('Window - Freeze Panes')
...
*

sorry to interject this, but how do you freeze specific panes? when
highlight a few cells and try to freeze pane, it freeze a specific pan
which has nothing to do with what I had highlighted, how do I fix this

 

[Frank Kabel]

Hi
Excel always freezes all row above and all column left to the current
cell position. So move the cursor for example to cell C4 to freeze
- rows 1-3
- columns A-B

highlighting won't help

 

[Seriak]

I viewed the code like you said and all that is listed is

Private Sub Workbook_Open()

End Sub

I see no scroll restrictions??

 

[Max]

If you'd like to, send me a copy of the file
via private email (to my address below)
and I'll have a look.