# of Macros ... What is max limit?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Excel 2000 ... Is there a Max number of Macros that can be
contained within a WorkBook? If so ... What is the "max"
limit ... Thanks ... Kha
 
Hi Ken
looking at the help file (Excel Specification'): The number of user
defined functions is only restricted by your memory
 
Thanks Frank ... I only record Macros & sometimes a little
cut/paste ... However, at one time not long ago I received
an error message that I interperted to mean I had exceeded
the allowable number of Macros. I only had 15 maybe 20 &
perhaps I interpreted error message wrong. Bottom
line ... if I am only limited by my memory ... this is
cool. Yeah, I say that, but maybe 15-20 is more than my
memory ... :)

Thanks for supporting this board ... Kha
 
Hi Frank!

Re: "The number of user defined functions is only restricted by your
memory."

And your ability to create or plagiarize from elsewhere. <vbg>

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Maybe you were hit not by the number of macros, but the size of the module.

Most around here say that excel has trouble with modules larger than 64k. You
can guesstimate the size of a module by exporting it to a .bas file and looking
at the size of that file.
 
Hi Frank!
Re: "The number of user defined functions is only restricted by your
memory."

And your ability to create or plagiarize from elsewhere. <vbg>
Click to expand...

:-)
so nearly unrestricted <vbg>
 
Back
Top