macros

[Guest]

I need to insert an image into our worksheets, each worksheet was created using macros. I'm not excatly sure how to add to the macro once it was created?
The image (which is our logo) needs to be on the right hand corner of each worksheet. Any suggestions

 

[Dave Peterson]

Record a macro when you do it once--say you call it AddLogo.

then add a macro to do all the sheets:


dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.select
call AddLogo
next wks

If that AddLogo does what you want, it should do it for all the sheets. (What
could go rwong? <vbg>)