Thread: Adding macro code to a new worksheet
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_915_] Simon Lloyd[_915_] is offline
external usenet poster
  
Posts: 1
Default Adding macro code to a new worksheet

;7346746 Wrote:
Hi,

I'm creating a workbook that will has an macro on sheet 1 which
creates a new worksheet with a table for tracking jobs.

What I need to do now is add some code to each new worksheet as part
of the macro on sheet 1.

This is where I have no idea what to do. The code on each worksheet is
basically code to run some batch files when a certain cell is
clicked.

What is the best way to do this?

ThanksIt's all very well explained and worked out here
http://www.cpearson.com/excel/vbe.htm regards,
Simon


--
Simon Lloyd
Reply With QuoteReply With Quote