Custom menu depth

  • Thread starter Thread starter R Avery
  • Start date Start date
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?
 
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.
 
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
 
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Excel 2007 with Excel 2003 template 1
Nested Sub Menus 3
Custom Menu Checkbox 1
Deleting custom menu item createt in VBA 1
Excel Popup Menu Control 2
VB - Macro to list all controls in the Commandbar. 8
MenuItem Check Mark 1
Context Menu 2007/2010 19

Back
Top