|
Posted to microsoft.public.excel.programming
|
|
|
FindControls ID
thank u very much Ron
"Ron de Bruin" wrote:
Hi Bogdan
See my site for screenshots and a link to a add-in and MS pages
http://www.rondebruin.nl/menuid.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Bogdan" wrote in message ...
Hi there,
I got a code which enables you to activate/deactivate certain menus/options
according to your needs. The code is like this:
Dim Ctrl As Office.CommandBarControl
For Each Ctrl In Application.CommandBars.FindControls(ID:=840)
Ctrl.Enabled = True
Next Ctrl
Do u know where can I get a comprehensive list of IDs and their meaning?
Thanking in advance,
Bogdan
|