blockage in excel sheet

S

shlomop

Somebody sent me an excel sheet, and somehow he blocked that I can’t g
after line 36, I tried all ways that I know, and I can’t figure i
out.
Can anybody help me figure this out?

Thank yo
 
O

Otto Moehrbach

If the rows beyond 36 are visible (as opposed to hidden), then the file
probably has a small macro in the Workbook module that sets the scrollable
range. Right-click on the Excel icon that is immediately to the left of the
word "File" in the menu that runs across the top of the screen, and select
View Code. That displays the Workbook module. Remove that macro or remark
it out (put an apostrophe at the beginning of every line in the macro).
Save the file, close the file, and open the file and see what you get.
If the rows beyond 36 are hidden (grayed out), click in the small square
immediately above the "1" in the row numbers. This selects the entire
sheet. then do Format - Row - Unhide - OK. This unhides all the rows.
HTH Otto
 
P

patele

Could be that they hid all the cells from 37 down and froze the window
if this is the case try the following:

Place your cursor on the 36 and you shoud get a black arrow. Left click
and while hold the button down drag the arrow downward. You may not see
it but it that action highlites all the cells from 36 down to the end.
Place your cursor back on the 36 then right click and select unhide. If
the cells are visible no further action is required however, if the area
below 36 is grey goto upper toolbar and select Window. If you see
Unfreeze Panes in the list click it. This should make all the cells
below 36 now visible. Hope this helps.
 
Top