Open Locked Columns to view code?

[kharpe]

Hi-

I have the task of backing into the code of another programmers use
form. I am pretty new to VBA so I'm stuck on one thing right now. I
the user form, I can see most of the formulas as they are called ou
there rather than with VBA. However, they reference cells in column
that are not visible. I can't scroll or view anything past column k.
am not sure how this is done in vba or what setting it is, but I hav
to get into this formula to edit it somehow. How would I do this?


Thanks! :confused

 

[Dave Peterson]

Try this against a copy of the workbook--just so you don't break it!

ctrl-A (twice in xl2003)
format|column|unhide
(in case they were hidden)

====
If the columns weren't hidden (you just couldn't scroll past a column/row)

hit alt-f11 to get to the VBE
hit ctrl-r to view the project explorer
Locate your workbook/project
select it
hit the asterisk on the number keypad to expand all the branches.
look for Sheet#(yourworksheetname)
under Microsoft excel objects.

You want to select the correct worksheet.

Hit f4 to see that worksheet's properties.
Scroll down until you see the ScrollArea property
erase any entry in that property.

Then back to excel to test it.