Copying Worksheets Question

[Guest]

If I need to duplicate Worksheets to distribute to teachers none of my Macros
or Toolbars duplicate or can be copied.

I know that we have a problem with Viruses getting into systems via the
Internet. The Microsoft Consulting Group however indicated to the school
boards that this can be done. However since they had no experience in coding
Macro's they did not know how to do it.

These would be Worksheets that I can burn onto a CD, and take it to a school
who needs the worksheets installed.

These Macros contain more than 3,000 lines of script, so it is very
difficult to copy and paste via NotePad.

Any assistance appreciated!


Len

 

[Guest]

what is the question?

 

[Guest]

Is it possible to copy a WorkBook so the Macro Code and Toolbars come with it?

 

[Dave Peterson]

Macros live in the workbook. You copy the workbook, the macros will travel with
it.

How did you create the toolbars and what files do the macros associated with the
icons point to?

You may want to move all the code out of the workbooks with the data and create
an addin that just supports the macros that was in that code. You may have to
rewrite your code to point to the activesheet (or maybe not???).

If you can't do that, you could create the toolbar modifications when the
workbook opens.

In either case, this may help:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)