J
Jeannette
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
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