PDA

View Full Version : Can't Get macro to run in Excel 2010



rkaczano
02-21-2012, 01:06 PM
In Excel 2010. Have a a Module with a Public Sub in it that I cannot seem to run. When I am in Excel and I go to the Developer Tab\Macros the marcos in the module do not shoe up in the list of macros. I am looking in ThisWorkbook.

When I go directly into the VBA Editor and I clickk at the top of the sub and then go Debug\Step-in, nothing happens.

The file is an xlsm file.

I have even gone into my Trust Center and enalbed all macros.

What am I donig wrong? Is there a new setting in Excel 2010 that I have missed?

Thanks

rkaczano
02-21-2012, 01:16 PM
Oops. Just realized the Sub had conditions in

Sub Thing()

vs

Sub Thing(ByVal drawBinTree As String, ByVal exboundary As String)

Was working with the latter and this is why I could not step into it.

Thanks