ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Runtime error 1004 (https://www.excelbanter.com/excel-programming/298128-runtime-error-1004-a.html)

Jeannette[_2_]

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


All times are GMT +1. The time now is 08:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com