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

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