R
R Avery
How deep can menus be? Can a menu have a menu have a menu have a menu have
a menuitem? Or is there some limit?
a menuitem? Or is there some limit?
T
Tom Ogilvy
I suspect you can go several levels deep - I believe I have gone at least as
deep as you show.
I don't recall seeing a published limit, but I suspect reasonable usability
would be exceeded before any limit is reached.
deep as you show.
I don't recall seeing a published limit, but I suspect reasonable usability
would be exceeded before any limit is reached.
B
Bernie Deitrick
R.,
Tom is correct: you would reach a practical usability limit before you
reach an Excel limitation: I wrote a recursive macro that added a
commandbar with 1200 levels, so the typical 255 and 1024 limits don't
apply.
I would try it with more but I'm afraid it would crash my machine and
I don't want to do that right now....
HTH,
Bernie
MS Excel MVP
Tom is correct: you would reach a practical usability limit before you
reach an Excel limitation: I wrote a recursive macro that added a
commandbar with 1200 levels, so the typical 255 and 1024 limits don't
apply.
I would try it with more but I'm afraid it would crash my machine and
I don't want to do that right now....
HTH,
Bernie
MS Excel MVP
R
R Avery
Thanky ;D
Bernie Deitrick said:R.,
Tom is correct: you would reach a practical usability limit before you
reach an Excel limitation: I wrote a recursive macro that added a
commandbar with 1200 levels, so the typical 255 and 1024 limits don't
apply.
I would try it with more but I'm afraid it would crash my machine and
I don't want to do that right now....
HTH,
Bernie
MS Excel MVP