Shared workbook and VBA problem

J

jeannette

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shared workbook and VBA problem 0
Runtime error 1004 0
Visual Basic in a shared workbook 4
Shared workbook error 1
Problem with Shared Workbook 0
VBA in shared workbook 5
Problems sharing a workbook created from External source 0
Still having problems with shared workbook 0

Top