Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bug with graphics | Excel Discussion (Misc queries) | |||
Graphics question on Excel VBA UserForm | Excel Programming | |||
API graphics question | Excel Programming | |||
VBA - graphics | Excel Programming | |||
Graphics | Excel Programming |