View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Duncan[_7_] Duncan[_7_] is offline
external usenet poster
 
Posts: 18
Default Help! Can't refer to a subroutine on a worksheet

I am writing a subroutine attached to a command button on a sheet that
looks through all the other sheets in the worksheets() collection and,
if applicable, runs the commandbutton1_click subroutine on each sheet.
Unfortunately different sheets have different commandbutton1 code but
the subroutine I'm writing needs to 'click' them all. I've made
commandbutton1_click public on each sheet.

No luck with worksheets(n).commandbutton1_click. Any suggestions how to
do this?

Thanks everyone!