Hello,

I am attempting to create a button in Excel and have it call a sub routine. If I remove the parameters from the sub routine, it is listed in the "macros" window and is an allowed assignment to the button. However, the moment I add ByVal Target As Range to the parameters list, it is no longer an option.

Why is this the case? Thank you!