Shared workbook and VBA problem
 

Shared workbook and VBA problem

Hi Group,

I am new at this Excel stuff and I am hitting my head on a silly
problem that I am sure many have seen before.
I wrote a very simple spreadsheet where I use the Calendar control to
pick some dates. Everything was fine until I decided that I needed to
share it on the network with other users.
As soon as I share it the calendar control stops working. I get a
"runtime error 1004, unable to set left property of oleobject class".
That's because the first thing I try to do is position the calendar.
If I don't do that, it still doesn't work. I tried to use a combobox
instead of the calendar and I have the same problem.
Is there something I am missing here between VBA and sharing?

Thanks,

Jeannette

jeanne8 AT eblw.com

Jeannette
aa6jh
Bristol 32, San Francisco
http://www.eblw.com/contepartiro/contepartiro.html