View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeannette[_2_] Jeannette[_2_] is offline
external usenet poster
 
Posts: 1
Default Runtime error 1004

Hello all,

I am new to this VBA thing. I am trying to write a fairly
simple spreadsheet for work. I use the Calendar control to
select dates. It works fine until I try to share the
workbook. I then get a "runtim error 1004, unable to set
the left property of oleobject class" when I try to change
the position of the object before showing it. even if I
don't try to move it, I get another error. Bottom line, I
can't get the control to work in shared mode. I tried a
combobox with the same results. I think it may have
something to do with some security settings but I am going
crazy looking for it.

Thanks, for your help. Can you plesae reply to jeanne8 AT
eblw.com

Jeannette