Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Shared Workbook | New Users to Excel | |||
Shared workbook start up problem | Excel Discussion (Misc queries) | |||
Shared Workbook Problem | Excel Discussion (Misc queries) | |||
Shared Workbook Problem, Urgent | Excel Discussion (Misc queries) |