View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eholz1 eholz1 is offline
external usenet poster
 
Posts: 32
Default Drawing Objects with vba and workbook/worksheet

Hello Usenet group Exelerometers,

I am using vba to draw a circle over a 2-cell range on a worksheet
(thank you for the tip on how to do this).

It seems that I cannot draw my circle on a worksheet in a workbook.
Does the worksheet in the workbook have to be active (aka ActiveSheet)
in order for
drawing to take place?

I have two workbooks - one is the workbook with a worksheet with
buttons, etc, and a bunch of VBA code to make things happen.
I click a button to open an existing workbook. None of the
sheets in the workbook I open are active. I click another button on
my sheet, and it performs some calculations on the book I opened. I
would like to draw a circle over a cell or cells after the calculation
process, but without making the various sheets active.

Thanks,

eholz1