Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menumaker problem
I'm using John Walkenbach's excellent Menumaker utility.
It has been working fine until I made a couple of alterations ......basically I added three more options. When I open excel2000 the addin loads the menu item, together with the submenu options. However my new three options do not load. If I now run the menu code manually, then the options do appear, and they work ok. Here's the layout in the addin sheet that the menu code takes it's data from: Level Caption Position/Macro Divider FaceID 1 &Valuation BofQ 10 2 &Open a Valuation OpenExistingValuation TRUE 23 2 &Close a Valuation (and Save Changes) Protect_Close_SaveVln TRUE 3 2 &Close a Valuation (without Saving Changes) Protect_Close_Vln TRUE 232 2 &With the Open Valuation... TRUE 3 &Remove all Protection RemoveProtection TRUE 3 &Protect the Valuation AddProtection TRUE 3 &Add a Standard Page AddStandardBofQPage TRUE # 3 &Add a Collection Page AddCollectionBofQPage TRUE # 3 &Add a Summary Page AddSummaryBofQPage TRUE # 2 &Choose a Valuation to Open and.. TRUE 3 &Calculate the Valuation Choose_Calculate_Valuation TRUE 681 3 &Print a Valuation (with options) PrintMultiBofQWorkbooks TRUE 2 &Valuation Utilities..Choose a Valuation and ... TRUE 3 &Check BofQ Total CheckTenderBofQTotal TRUE 3 &Copy Tender Quantities into Valuation Column CopyTenderToVlnQuantities TRUE 3 &Remove Valuation Quantities and Client Totals RemoveTenderBofQTotalAndVlnQuantities TRUE 3 &Remove Client Total RemoveTenderTotals TRUE 3 &Remove Valuation Quantities RemoveValuationQuantities TRUE The new entries ara marked as '#'. Would be grateful for help, please. Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
menumaker.xls | Excel Programming | |||
Menumaker.xls Create Macro on User Toolbar | Excel Programming |