Macro Problems

[mlopes1]

I posted an earlier question about problems with a macro, but in trying to figure it out, have come across a lot larger issue:

I have a template that I am working on right now. When it is complete, I want to copy this template as another template for 80 or so different company folders. For example: Original.xlt becomes company1.xlt - company80.xlt

The end users will be using the company templates, not the original that I have made.
As part of this template, I have a custom toolbar with 5 separate buttons that run macros.

I seem to be having problems with some of these macros. Its as if somehow excel remembers the last workbook that the macro was used for, and therefore the buttons stop working when I try to use it in a new workbook. One example is:

I have a macro that simply changes the file status to read/write. It works fine on the original, but on any of the other workbook templates, when clicked, it tries to run on the workbook that was open the last time it was clicked. The code uses Activeworkbook.etc.etc... I never specify a named file.

basically I want these macros to be universally used by all the templates. How can I do this?

I hope I am explaining this ok. it seems confusing to even type. I hope someone can help.

Thanks.

Mark

 

[Richie(UK)]

Hi Mark,

Not entirely sure that I follow you - are the macros designed to work on the workbook that they are contained in (ThisWorkbook) or the currently active workbook (ActiveWorkbook) ?

 

[mlopes1]

Hey Richie,

Currently the code reads:

Sub Button3_Click()

Application.Dialogs(xlDialogSaveAs).Show
End Sub

I have this code in Module 1 of the Original.xlt template.

I am then copying and pasting this template into the folders of 80 "companies". I then rename the files Company1.xlt, Company2.xlt...etc.

The custom toolbar (with the saveas button that currently isnt working) is made visible in the onOpen event, so each template copy also makes the toolbar visible.

I hope that clears it up a little.


Oh, and by the way. If I create the button and assign the exact same macro, except I place it on the worksheet, and not in a toolbar, it works fine! That is Plan B, but i would rather it be on the toolbar.
Mark
This message was edited by mlopes1 on 2002-08-23 09:25