Forum Home
Press F1
Thread ID: 20149	2002-05-30 09:56:00	Excel assign button to macr	Guest (0)	Press F1

Post ID	Timestamp	Content	User
51594	2002-05-30 09:56:00	I'm having difficulty getting the 'assign macro' box to appear when I have placed a button on a worksheet. I can create the macro ok. I can get the button to appear on the worksheet but I can't get the assign box to appear so as I can link the macro to the button??? Any help will be appreciated. Many thanks. Chris	Guest (0)
51595	2002-05-30 11:13:00	The Assign Macro box should appear immediately the macro button is placed on the worksheet. Make sure that the macro button tool you are using is from Commands/Forms and is called Button. Right click the tool bar and select Customise to do this and drag this button onto the tool bar and select this button to draw the macro button on the worksheet. HTH	Guest (0)
51596	2002-05-30 22:15:00	As noted above make sure you have the right type of button created. Also make sure the page is in Unprotected mode when doing that and following. Right click the button and you should get a pull down menu which includes the Assign Macro option also options for formating and moveing etc	Guest (0)
51597	2002-06-02 07:08:00	Thanks Russell I have done what you suggested and yes it has worked well. As a result of your suggestion I was able to see where I was going wrong. I was trying to get the 'Control Toolbox' icons to do what I should have been using the 'forms' buttons for. Thanks again. Chris.	Guest (0)
1