View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
glenn glenn is offline
external usenet poster
 
Posts: 122
Default INSERT PICTURE IN MACRO

oK i WANT TO RY THIS AGAIN. i AM A NOVICE SO PLEASE HELKP ME UNDERSTAND.
sorry...I do know how to record a macro but the help is needed to:

I want to build a macro that will allow a picture,clipart, to be inserted on
one worksheet if in another worksheet a cell ---let's say is true. How to do
this??? Does the clipart have to be on the page when recording the macro???
What is the programing to record??? Lets's say that :

In worksheet 1 that B3="3"
Macro would then insert the clipart in worksheet2 in a given spot because
B3 in worksheet one was equal to "3"

Hope I am making since:)
Glenn