excel 4 macro migration to excel 2007

[jeffrey]

i have many extensive customized programs I have written using excel 4 macro
language. I have now reached a worksheet approaching 65000 rows of historical
data. i bought office 2007 so that I will have unlimited rows.
Dilemma is that my excel 4 programs will not run. My custom buttons don't
respond on click, when I open the macro page and right click on any line to
try to run the macro step fashion, the run is not highlighted as accesible.
I have enabled all macros on option area.
Please help me to get these very important excel 4 macro applications to run
again...or if possible to extend the number of rows available on any
worksheet on an earlier version of excel
Thanks big time.

 

[Jim Rech]

i bought office 2007 so that I will have unlimited rows

1,048,576 anyway.

Mine run okay. It might be a security setting but I don't know what it is.
Do you get any kind of message? A message box or a warning bar above the
worksheet window?

It's not.

--
Jim
|i have many extensive customized programs I have written using excel 4
macro
| language. I have now reached a worksheet approaching 65000 rows of
historical
| data. i bought office 2007 so that I will have unlimited rows.
| Dilemma is that my excel 4 programs will not run. My custom buttons don't
| respond on click, when I open the macro page and right click on any line
to
| try to run the macro step fashion, the run is not highlighted as
accesible.
| I have enabled all macros on option area.
| Please help me to get these very important excel 4 macro applications to
run
| again...or if possible to extend the number of rows available on any
| worksheet on an earlier version of excel
| Thanks big time.

 

[Jon Peltier]

or if possible to extend the number of rows available on any worksheet on

It's not.

Though if you're clever you can use multiple sheets, or even multiple
columns in one sheet, snaking from the bottom of one to the top of the next.

- Jon