Bob

Thanks for that, does exactly what I'm after.

Steve

On Fri, 22 Sep 2006 10:06:44 +0100, "Bob Phillips"
wrote:

Application.Commandbars("Worksheet Menu
Bar").Controls("Tools").Controls("Macro").Enabled =False