Hi,
Sorry if this is in a FAQ that I haven't found, but I'm on a short deadline.
I have inherited an Excel 2007 spreadsheet with VBA code that's functional (e.g. if I enter a different value in a field, the result fields change appropriately). I've figured out how to show the developer tab, etc. - but when I try to view code in that sheet, all I see is:
---------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
------------------------------
That appears to be the case in every one of the 10 or so sheets in the .xlsx file.
I see an asterisk'ed field in the <Properties - ThisWorkbook> window. I would guess
perhaps that's the issue? If so, and assuming I can find out what the password is,
how would I enter it - so that I can look at and modify the code?
BTW, I've been a C programmer for 30 years, so it's not a concept thing - but rather,
a MS Excel IDE (if you want to call it that interface an IDE
) thing.
Thanks!
Sorry if this is in a FAQ that I haven't found, but I'm on a short deadline.
I have inherited an Excel 2007 spreadsheet with VBA code that's functional (e.g. if I enter a different value in a field, the result fields change appropriately). I've figured out how to show the developer tab, etc. - but when I try to view code in that sheet, all I see is:
---------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
------------------------------
That appears to be the case in every one of the 10 or so sheets in the .xlsx file.
I see an asterisk'ed field in the <Properties - ThisWorkbook> window. I would guess
perhaps that's the issue? If so, and assuming I can find out what the password is,
how would I enter it - so that I can look at and modify the code?
BTW, I've been a C programmer for 30 years, so it's not a concept thing - but rather,
a MS Excel IDE (if you want to call it that interface an IDE
) thing.Thanks!