View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Graphics question

Is it possible to place a series of graphics (I have created 1 for each of
our allowed holidays) on a worksheet, and then using code copy the graphic
to another worksheet in the same workbook?

I have created a Template for our vacation calendar so we do not have
recreate it each year. When I start a new year I have conditional formatting
which removes all lines on the calendar for each of the holidays. Then I
want to paste the holidays graphic on the calendar. So say for Christmas I
have a graphic which is named Christmas.gif which I have inserted on a blank
(hidden) worksheet which I would copy to cell B44.

I envision having SheetActivation code which would look something like:

If range ("B60").value = "Christmas" Then

and then the code to copy the graphic Christmas from the hidden holiday
worksheet to cell B44 of the active worksheet.