Send parameters in worksheet button 255 characters
 

If I create a Forms (not ActiveX) worksheet button, I can send
parameters in the OnAction parameter, like this:

MyButton.OnAction = "'" & strThisWorkbookName &
"'!'Clicked_My_Button(" & my_arg & ")'"

However, I'm limited to a total OnAction string of 255 characters. I
want to send many long parameters, requiring much more than 255
characters.

Is there any way I can do this with ActiveX worksheet buttons, or any
other way to get around this limitation?

I'm using Excel 2007.


Thanks,

Greg