View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil Strong Neil Strong is offline
external usenet poster
 
Posts: 1
Default Calling Subroutines/User Functions from Macros

I've a number of sheets in a workbook

One sheet has a button which calls

Private Sub DoPreStock_Click()

I'd like to be able to call this sub from a macro ( E.g.
Sheet3.DoPrestockClick()), invoked from a menu, but don't
know the syntax ( Or even if it's possible ).

Can someone help please.

TIA
Neil