LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 414
Default Making modifications to macro module from R. De Bruin

Yes, I'm back again with another question about the menu macro.
In setting up the macros I found that I'm limited to 3 levels.
In general that's plenty, but I wanted to add a fourth level for a specific
set of macros.
What is involved in adding a fourth level to your menu macros?
I've tried the following:
At the "IF NextLevel = 3 Then" statement, I changed the number from 3 to 4
(thinking that it'd allow me to make a fourth level.); this did not work, and
instead called an error at the second line in the Case 3 ' A SubMenu Item
" Set SubMenuItem =
MenuItem.Controls.Add(Type:=msoControlButton)"
Thanks again for your time.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Statement Modifications Workbook Excel Worksheet Functions 9 February 19th 09 01:55 PM
webbrowser - excel - modifications [email protected] Excel Discussion (Misc queries) 1 January 26th 06 04:31 AM
Ron de Bruin Copy2 Macro - troubleshooting gizmo Excel Worksheet Functions 3 January 18th 05 02:47 PM
Making Contents of a cell input for a Module anyuan Excel Programming 0 June 28th 04 06:49 AM
Modifications to Permutation Macro Henrik[_2_] Excel Programming 1 October 24th 03 06:53 PM


All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"