Auto add same Text box to EVERY chart

[Welshbird]

Hi Chaps,

My boss has asked that everytime any of our team supply a chart to the business that we mark it with a text box (or something similar) to indicate its source.

So, for example: a text box with the words:
Fab Team, Our Company Ltd.

At the moment I'm just adding a text box each time, but that might make them look slightly inconsistent over time.

Is there a way I could automate tis so this would always happen?

Any advice much appreciated.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

Hi,

Not really. You mean any time someone in the company might INSERT a table, some Add Chart event would also Add a formatted textbox?

That's called "Standard Operating Procedure" in most companys. You might make a template that could be copied, like a logo, but the discipline it on the employee.

That is, unless you want to write you own Spreadsheet application that automatically does what is described above. But I'd wager it would be much MUCH less useful than Excel.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Welshbird]

At the moment I've just written a macro to add it, and bunged that on my own customised ribbon.

It was just really to find a way for my team (4 people only) to have that automatically, but it sounds like I should add this to my 'team-addon' and simply put it on each persons ribbon.

Thanks for help though,



Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

That's what I would do, also.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}