Thread: calling a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jhahes[_25_] jhahes[_25_] is offline
external usenet poster
 
Posts: 1
Default calling a macro


How do I call a macro, for instance I have 50 sheets on every sheet I
want to put a command button to go back to the main page (Sheet1). How
do I create one macro that goes Sheet1.activate and be able to call that
to run. I am new to the terminology of vba. Do I have to create a new
module or put it in this workbook?

Thanks for any help


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=392594