View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Automatically Assigning a Macro to a button

Not Dave, David.

(and not David McRitchie, either! Well, unless he wants to???)



Bob Phillips wrote:

"Dave Peterson" wrote in message
...
Building on Bob's reply:

Option Explicit
Sub testme03()

On Error Resume Next
Worksheets(ActiveSheet.Buttons(Application.Caller) .Caption).Select


That's neat, like it.

If Err.Number < 0 Then
MsgBox "Design error. Contact David!"


Are you offering a Help Desk service Dave<vbg?


--

Dave Peterson