Custom menu depth
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? |
Custom menu depth
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. -- Regards, Tom Ogilvy "R Avery" wrote in message ... 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? |
Custom menu depth
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 -- HTH, Bernie MS Excel MVP "R Avery" wrote in message ... 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? |
Custom menu depth
Thanky ;D
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... 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 -- HTH, Bernie MS Excel MVP "R Avery" wrote in message ... 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? |
All times are GMT +1. The time now is 04:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com