View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
barkiny[_5_] barkiny[_5_] is offline
external usenet poster
 
Posts: 1
Default macro for all open worksheets?


i have 1500 worksheets all the same format
i have recorded a macro for workbook 1
i want to run the macro the other 1499 sheets

is there a quick way to run the macro without pressing run macro key
and select the macro and..............., (like grouping worksheets) ?


--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=490136