Okay,

I've figured out the how to create the macro. The problem that I'm
having now is that in the custome header and custom footer we have an image
with our company logo (header) and an image with our company slogan (footer).


I'm having difficulty figuring out how to have the macro add the images.

"Pugs" wrote:

Gord,

Thanks for the quick reply. I have thought about using macros, but
unfortunately that's a little beyond my knowledge level. At least one of the
consultants has to have that skill set, though, so I'll be checking with
them.

Thanks again.

"Gord Dibben" wrote:

Yes, you would have to have your personalized SHEET.XLT in the Xlstart folder.

Have you thought about a macro in the Branded Workbook Template to insert a new
Excel default sheet and code to add the Header/Footer customization to that
newly inserted sheet?

Your consultants would then only need the Branded Workbook Template.

Any workbook based upon the Template would have the macro.


Gord

On Mon, 11 Feb 2008 14:21:23 -0800, Pugs wrote:

I would just like clarification. If we were to have a branded workbook
template available for our consultants to download and use at a client site,
in order for new sheets to be inserted into the template with our branding in
the header/footer, they would need to download and save SHEET.XLT into the
XLSTART folder of whatever machine they're located at?

Is there any other way to have that branded header/footer show up in newly
inserted sheets without overwriting the SHEET.XLT on the machine they're at?
Our consultants often get assigned a client owned computer when they are at
client sites.



"Gord Dibben" wrote:
You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.