Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Shared Workbook PA New Users to Excel 0 April 21st 08 09:06 PM
Shared workbook start up problem WendiL99 Excel Discussion (Misc queries) 2 June 26th 07 06:22 PM
Shared Workbook Problem Bobby G Excel Discussion (Misc queries) 0 April 5th 06 06:52 AM
Shared Workbook Problem, Urgent calimari Excel Discussion (Misc queries) 2 July 8th 05 07:48 PM


All times are GMT +1. The time now is 07:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"