PDA

View Full Version : [SOLVED] What happened to this sheet



anandbohra
09-03-2007, 06:12 AM
hi all
i had downloaded certain files from smf addin yahoo group
the strange thing i noticed is there is no VBA but there is only limited scope to browse the worksheet (say only range A1:J150)
pl look this & detailed me if any body have any idea

rory
09-03-2007, 06:21 AM
You can run code once to set the ScrollArea property of a worksheet to a particular range. You don't need to store the code in the workbook.
You can also set the Scroll Area directly in the properties window in the VBEditor.

anandbohra
09-03-2007, 09:49 PM
Thanks rory but in VBEditor when i set the Scroll area to $A$1:$J$10
this shows whole sheet but scrolling is limited in this area only.
but in the attached file as u can see after column M there is grey shaded area which let us feel that sheet has only column m instead of column IV
same way after row 152 u can not see below is which again looks like this is small sheet of column M by row 152 instead of standard Column IV by Row 65536.

hope u got it.

Pl tell me how to do that as u can see in the attached file (already attached in 1 post named limited data.xls)

mdmackillop
09-03-2007, 11:59 PM
The rows and columns are hidden. Select the whole area and unhide rows and columns or

Sub unhide()
With Cells
.Rows.Hidden = False
.Columns.Hidden = False
End With
End Sub

anandbohra
09-04-2007, 12:14 AM
Thanks mdmackillop
I wonder how come this small thing missed in my mind :eek:just unhide cells.:dunno

thanks to all