View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default how do i prepare a macro to insert drawing object on specific cell

Hi,

Record it, then if it doesn't work post the code and we can modify it.
(Don't know what you mean by "run" on each sheet?

Turn on the recorder - choose Tools, Macros, Record New Macro, give it a
name without spaces, and click OK. Do the steps you want on one of the
sheets and then turn off the recorder.


Cheers,
Shane Devenshire

"Harshad" wrote:

I have 54 sheet WB. I have a drawing, which i want to run on Each sheet named
"Exp..".The drawing is a chemical reaction drawn from chemistry software ISIS
Draw. Unfortunately i can't past it here.