Viewing Hidden Cells

Posted by Lee Hitchen on January 25, 2002 1:43 AM

I have received a spreadsheet which is password protected. Is there any way I can 'view' data stored in a column (which is hidden) without having the password to unlock the sheet? I've used the 'goto' function but it does not revela what is recorded in the cell/column.

Thnx in advance

Lee

Posted by Mark O'Brien on January 25, 2002 8:07 AM

I think that might be the whole point of being able to hide the columns and then add password protection. Although, I could be wrong.

Posted by Mark O'Brien on January 25, 2002 8:10 AM

Actually, I've just been able to view data in a hidden column using VBA. I just used this line to view data in cell "B1" of "Sheet1" which was in a hidden column and protected workbook. Bizarre. Anyway, you can play about with the code I guess. Hope it works for you.

MsgBox Sheets("Sheet1").Range("B1").Value & vbNewLine & Sheets("Sheet1").Range("B1").Formula