Cannot access all parts of worksheet

  • Thread starter Thread starter marpat
  • Start date Start date
M

marpat

I've taken over a worksheet, I am unable to access the whole sheet ie. cell
AC33. the cursor won't go past column J. It is saved as an excel file but
perhaps was created using another program (VB?) which I'm not familiar with.
The columns that are unaccessable are a light blue color the rest is white,
there are cell references to the unaccessable. I've checked if the sheet is
locked/protected and it doesn't appear to be. Any help is appreciated.
 
.. the cursor won't go past column J.
Sounds like the orig. author of the file might have scroll-area locked it
using vba. Suggest you get back to him/her if it is vital to you that the
entire sheet be accessed.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
 
In Xl2002 or better one of the options when protecting a sheet is to not
allow access to locked cells. That is my guess as to what is going on.
Unprotect the sheet and you will get access to those cells. If you do not
have the password just reply back...
 
Hi,

1. to test if it is a protection issue, choose Tools, Protection and note if
any of the commands say Unprotect.
2. to test if it is a locking of the scrollable area choose View, Toolbars,
Control Toolbox. Click the Property tool (hand over a sheet of paper). In
the Properties box check to see if there is a range listed to the right of
the ScrollArea property. If so remove it. This property is ofter set using
VBA, so you may have to remove the VBA to prevent this from happening each
time you open the file.
 
The columns that inaccessible are colored light blue for the entire columns
or just the column headers?

See also my posting in reply to Max's posting


Gord Dibben MS Excel MVP
 
Got stuck in my Outbox<g>

Here is a new one.

Max/Marpat

Scrollarea settings do not survive a file>close.

Scrollarea must be set at workbook_open or at sheet_activate.

OP would have code in either Thisworkbook or in the sheet module if
scrollarea is being set.

I suggest looking through those modules for code.


Gord
 
Scrollarea settings do not survive a file>close.
Scrollarea must be set at workbook_open or at sheet_activate.
Click to expand...

Yes, think I recollected that bit, Gord. But I wasn't sure if the orig.
author of the file would probably have locked the vbaproject as well.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
 
The sheet is not protected, When I check properties in VB (though I really
don't understand it) in the scrollarea the box to the right is blank. When I
view the code this is all I see:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

Cannot contact the author of the sheet so.....

The whole area to the right (which I can't access is blue)
 
Perhaps those columns to right are simply hidden?

CTRL + a(twice) to select all then Format>Columns>Unhide.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
"cannot shift objects off sheet" error 8
worksheet cells fill with color after typing 3
Printing Multiple Worksheets 3
Cell value as part of a worksheet ref. in Excel 2
Summary Worksheet. 1
Blank cell revisited 1
summing across worksheets conditionally and being able to copy for 4

Back
Top