Unable to run macro

[HuaminChen]

Hi,
To the file below, why can't I run the macro inside it?
https://1drv.ms/x/s!Ai8CrEskdewXm1EtunChN-NFqXkj

 

[Michael M]

I'd suggest posting the macro here, with what is / isn't happening in the worksheet, BEFORE anyone opens your file !!

 

[HuaminChen]

Here is the macro
Sub c()
Dim btn As Button
For Each btn In ActiveSheet.Buttons
Debug.Print "Button " & btn.Name & " with caption " _
& btn.Caption & " Located at " & _
btn.TopLeftCell.Address
Next


End Sub

 

[Michael M]

What sort of buttns..., userform,command, activeX, shapes?
your workbook on onedrive doesn't show any buttons !

 

[HuaminChen]

The ones highlighted below are buttons, right?
https://1drv.ms/u/s!Ai8CrEskdewXm1LaFYJZ_BYzZJq3

 

[Michael M]

Rclick on one of them and tell us what it says in the name box (just above column "A")

 

[HuaminChen]

I only get the below
https://1drv.ms/u/s!Ai8CrEskdewXm1OmfN6roMdv2rrE

and cannot choose properties of it.

 

[Michael M]

Try this

Sub MM1()
For Each cb In ActiveSheet.Buttons
    If TypeName(cb) = "Button" Then
        MsgBox cb.Name & " is located at " & cb.TopLeftCell.Address
    End If
Next cb
End Sub

 

[Macropod]

Cross-posted (and time wasted going over the same ground) at: http://www.msofficeforums.com/excel-programming/40909-unable-run-macro.html
Also cross-posted at: https://www.excelguru.ca/forums/showthread.php?9584-Unable-to-run-macro

Please read (and acknowledge) Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[Michael M]

Thanks for the heads up Paul....