Excel 4 macro sheet help

[Jaymond Flurrie]

I have an Excel 4 Macrosheet that resides inside a xls-file. The sheet looks like it's blank, all the rows and/or columns are hidden and not even headers are shown. I've never even seen an Excel 4 macro sheet before. What can I do (with VBA or Excel 2003 or 2010) to see the actual XLM code? Would it help to receive from somewhere older Excel version?

 

[mikerickson]

Have you un-hidden the rows and columns?

 

[Jaymond Flurrie]

I have no idea how to do that. I mean, what's the VBA syntax for that? I've never seen an Excel4Macrosheet object before. Since there's not even row headers, I can't just doubleclick for autoheight like in a normal Excel sheet. Same goes for columns.

 

[pgc01]

Since there's not even row headers

??

Check in the options:

Excel options->Advanced in the section "Display options for this worksheet" check the "Show row and column headers".

Maybe this option is not set?

 

[Jaymond Flurrie]

??

Check in the options:

Excel options->Advanced in the section "Display options for this worksheet" check the "Show row and column headers".

Maybe this option is not set?

Done. Now I can see the "select all cells" "button" above the supposed row 1 and left of supposed column A.

 

[pgc01]

Good. And are you seeing the code now?

 

[Jaymond Flurrie]

No. It looks like... A sheet that has 0 rows and 0 columns. I am able to recover some code by using direct cell references to the sheet, but since I have no idea where exactly the code is, I can't copy the code from there just like that.