Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Chart Class Error (excel 2000)

    Hi all,
    I have a SpreadSheet that I would like to share, but can't because I can't fix a Run Time Error 1004 Unable to set the width Properties of the ChartObject Class. The Spread Sheet works fine when not shared, I get that error once I share it.

    Any ideas, I would like to post it here, but the file is too big.

    Thanks, Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart Class Error (excel 2000)

    Sharing Excel workbooks is a weak feature. I have always avoided using it. Do you really need multiple users to be able to edit the workbook? If most users only need to view it, you don't need to share it - if one user has the workbook open, others can open it read-only.

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Chart Class Error (excel 2000)

    Hi Hans,
    Thank you for the idea, I never really considered that option, of not sharing the file. It might be my only alternative in this matter. But a solid solution, none the less.

    This is where I would like to be able to go in and fix the problem, but at this level of programming, I do not have the talent

    Thanks,
    Darryl.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Chart Class Error (excel 2000)

    You could comment out the line of code if it is not needed...

    Sharing limits the things that can be edited in a workbook, so other than not trying to do the "illegal" things, there is not much other coding you can do.

    A followup to Hans' suggestion. We have several workbooks we use at my work location that I have a "modify password" set (you have to enter a password to modify it, you need no password to open it). When people open it, it pops a dialog box for a password (for modifying), that people just acknowledge, and it is opened read-only. All can open to view it at the same time, and the few of us who have access to modify it, can do so without worrying about others who might have it open.

    This senarios does assume that most people just need to view it and do not need to edit and save it.

    Steve

  5. #5
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Chart Class Error (excel 2000)

    Hi Steve,

    Just so I understand what you are saying, how would you determine who has access to edit the file? Actually, I tried what Hans suggested, works fine, but what if Someone forgets to close the workbook so that others can view it? Or even edit it? Is there a way to by pass the read only option?

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Chart Class Error (excel 2000)

    That is what is nice about the scheme. Someone can have it open all day and it won't matter. Anyone else can open it and view it since they all open it read only.

    If you want to edit it, just enter in the password at the prompt and you have exclusively rights to edit. Excel knows who has access to edit the file, since they will enter the password. If they do not enter the password it is opened read only...

    Steve

  7. #7
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Chart Class Error (excel 2000)

    Steve,

    How do I set that up, with the protect workbook? I know in Word it has that option in the properties of the document, but I didn't see it in Excel. Is this done in code, or is it done in the workbook?

    Thanks,
    Darryl.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart Class Error (excel 2000)

    Select Tools | Options...
    Activate the Security tab.
    Enter a password in the "Password to modify" box and press Enter.
    You'll be asked to confirm the password.

    Alternatively, you can select Tools | General Options... in the File | Save As... dialog.

  9. #9
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Chart Class Error (excel 2000)

    Just wanted to close this thread by saying thanks to Hans and Steve.

    Some times the solution is easier than you think.

    Darryl.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •