ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Problem Assigning Macros (https://www.excelbanter.com/excel-worksheet-functions/31316-problem-assigning-macros.html)

Rafe

Problem Assigning Macros
 
I am attempting to assign a macro to a button I have created in a worksheet
in Excel 2002. I have worked with other versions of Excel without issue, but
for some reason, when I go to assign a macro to the button I created, there
is no option for me to "Assign Macro". I'm afraid I'm not saavy enough to
write code, so I need this function to operate. I have a major presentation
on Monday and I desperately need some guidance.

Thanks,

Rafe

LanceB

use the button from the forms toolbar rather than the one from the control
toollbar.

The "Forms" button asks you to assign it to a macro

"Rafe" wrote:

I am attempting to assign a macro to a button I have created in a worksheet
in Excel 2002. I have worked with other versions of Excel without issue, but
for some reason, when I go to assign a macro to the button I created, there
is no option for me to "Assign Macro". I'm afraid I'm not saavy enough to
write code, so I need this function to operate. I have a major presentation
on Monday and I desperately need some guidance.

Thanks,

Rafe


bj

Right click on your button and the assign macro is one of the options.

"Rafe" wrote:

I am attempting to assign a macro to a button I have created in a worksheet
in Excel 2002. I have worked with other versions of Excel without issue, but
for some reason, when I go to assign a macro to the button I created, there
is no option for me to "Assign Macro". I'm afraid I'm not saavy enough to
write code, so I need this function to operate. I have a major presentation
on Monday and I desperately need some guidance.

Thanks,

Rafe



All times are GMT +1. The time now is 04:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com