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.

i bought office 2007 so that I will have unlimited rows

1,048,576 anyway.

Dilemma is that my excel 4 programs will not run

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?

or if possible to extend the number of rows available on any worksheet on
an earlier version of excel

It's not.

--
Jim
"jeffrey" wrote in message
...
|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.

or if possible to extend the number of rows available on any worksheet on
an earlier version of excel

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Jim Rech" wrote in message
...
i bought office 2007 so that I will have unlimited rows

1,048,576 anyway.

Dilemma is that my excel 4 programs will not run

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?

or if possible to extend the number of rows available on any worksheet on
an earlier version of excel

It's not.

--
Jim
"jeffrey" wrote in message
...
|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.