Assign macro in command button sub-menu

Giganews Newsgroups
Subject: Assign macro in command button sub-menu
Posted by:  Bill A (wpayr…@tva.gov)
Date: Mon, 6 Oct 2003

The instructions in Excel XP say to drop a command button
in the spreadsheet, right click on it, and select the
assign macro option in the sub-menu in order to assign a
macro to the button.

When we right click on the command button and bring up the
sub-menu, there is no assign macro option in the sub-
menu.  (None of the computers set up by our IS group has
the assign macro option in the sub-menu.)

Does anyone know:

1)  How do I get the assign macro option to appear in the
sub-menu?

2)  What caused the option to not appear in the sub-menu
(glitch in software, problem in installation, security
switch, etc.)?

Thanks,

..

Replies