Have to alter existing sheet but can't find cells to alter.

[limpopo]

Hi all,

Just to start, I'm not an Excel expert and just have basic skills.

The situation is that i have an existing Excel sheet that was created a couple of years ago by another person who is no longer available.

At a basic level, the section i want to alter has a box in which you input a code and it appears that the VLOOKUP function is then used to check a table of values and return the relevant response against the input code. The response appears in another box.

The code is input in C7

The corresponding value appears in cell D7

The code that is in D7 is as follows;

=IF(C7="","",VLOOKUP(C7,'codelookup'!A2:D385,2,FALSE))

What i need to do is alter some of the values that are returned against the various codes that are input in C7 as the values have changed.

Being an amateur it appears to me that these values are hidden somewhere . I cant scroll down to have a look at D385 as the sheet stops scrolling at row 200.

Does anyone have any clues please ??

Thank yo

 

[MARK858]

Can you run the code below just to make sure it is now unprotected.

Sub IsWorkbookProtected()

With ActiveWorkbook

If .ProtectWindows Or .ProtectStructure Then

MsgBox "This workbook is protected"

Else

MsgBox "This workbook is not protected"

End If

End With

End Sub

 

[limpopo]

"the workbook is protected"

I didnt realise the difference between protecting workbooks and sheets.... i think i have the PW though but where does it go?

 

[limpopo]

BINGO ! I have it !,,

found the review>unprotect workbook dialogue, used the VBA thing to set sheet 37 to unhidden and the sheet is now visible..

Thank you all so much for your help and perseverance.

Ive learned a lot