Control button linked to Userform Excel for Mac

[leopardhawk]

I have a very large workbook, years in the making, with lots of code, links to the Internet etc. After months of testing, I am confident that it works 100% perfectly in Excel for Windows on a Windows PC. Now, I have begun testing in Excel for Mac on an Mac PC and have found what I hope is a relatively small problem that someone here can help me with.

There are 13 command buttons on the Home worksheet and 11 of them work just fine (they link to other worksheets) but, there are two command buttons that both launch Userforms where the users will input their data. On the Mac, these two buttons do nothing, the cursor doesn't change to a 'hand' like it does with the other command buttons. Clicking either button just highlights the button.

If anyone can help point me in the right direction on this, I will be grateful. Thanks!

 

[leopardhawk]

@Fluff Ahhhhhh!!

When I right-click the button (in Design Mode), there is no option to 'assign macro'. Am I missing something? I never actually used the macro function, I just went into VBA and wrote that code that I sent earlier.

 

[Fluff]

You need to use either a form control button or a shape. ActiveX controls do not work on Macs.

 

[leopardhawk]

@Fluff Thank you so much for your efforts. I really appreciate it.

 

[Fluff]

Glad to help & thanks for the feedback.