Diable a macro after use

[Ian Mangelsdorf]

I have an application with a "Setup routine" I would like the users
to be able to run this routine once and then diable the routine. I am
using menu items so I thought there may be a way to disable the menu
item by using

ActiveWorkbook.CommandBars("&RCA Menu").Controls("Job Setup").Enabled
= False

Am I using command bars properly here and if so then what is the
correct way of disabling a command bar item

Cheers

Ian

 

[Guest]

Did you try just deleting the setup option from the menu at the end of the macro