Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Template (Excel 2003 / 2000)

    Hans I need a miracle. We are sending Excel 2003 files saved as Excel 2000 out with cells being write protected. If a user receives this file the whole worksheet is protected and not only the dedicated cells. Are their (please) and easy workaround. We need to receive the files back still intact.

    Regards

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

    Re: Excel Template (Excel 2003 / 2000)

    Please don't direct questions to me personally. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    What do you mean by "saved as Excel 2000"? The file format for Excel 97, 2000, 2002 and 2003 is the same.

    How are the users opening the workbook? Directly from an e-mail? If so, let them try saving the attachment to disk and opening it from disk.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2003 / 2000)

    I've asked our IT to give me the code that they use to protect the range as well as where they save it:

    UnprotectRanges(mcRangesToUnprotect, wsTemplate, DescriptionForWarning, HeadingForWarning)
    wsTemplate.Protect(CType(AppSettings("Password"), String))
    CheckOkayForSave(FileName, ".xls")
    wsTemplate.SaveAs(FileName, XlFileFormat.xlExcel9795)
    wbTemplate.Saved = True
    wbTemplate.Close()

    To test the situation I've saved the workbook on a CD and opened it on the Excel2000 machine. I cannot edit any of the ranges including those that is editable in Excel 2003

    TIA

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

    Re: Excel Template (Excel 2003 / 2000)

    This doesn't help much, since it refers to other VBA code (UnprotectRanges, CType, AppSettings, CheckOkayForSave).

    But there is no reason to save a workbook in Excel 97/95 compatibility format if you want to use it in Excel 2000. Excel 2000 uses exactly the same file format as Excel 2003.

    Oh, and if you open a workbook directly from a CD, it will be read-only.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2003 / 2000)

    I've tried to save the workbook in all the available formats of save as. The whole sheet is protected if I open it in Excel 2000. Any ideas more ideasworkarounds PLEASE

    TIA

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

    Re: Excel Template (Excel 2003 / 2000)

    Let's try a simple test. I have attached a workbook created in Excel 2003. The worksheet is protected but the cells with a yellow background are unlocked.
    Download the workbook to a PC with Excel 2000 and open it there. Can you edit the cells with a yellow background?
    Attached Files Attached Files

  7. #7
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2003 / 2000)

    I don't understand this. Your file I can edit. WHY? Can you maybe see something in the code that they stuff it up with. How should they be saving the file then. Thanks

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

    Re: Excel Template (Excel 2003 / 2000)

    They should not specify a format when saving the file. It'll be saved as a normal Excel workbook by default:

    wsTemplate.SaveAs FileName

    or, if you prefer

    wsTemplate.SaveAs FileName, xlNormal

  9. #9
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2003 / 2000)

    Hans I don't understand it. We've changed the code and created the template. If I take that template to the Excel 2000 I can't edit the range. If I then unprotect the worksheet and go to Format cells that range is Locked. With Excel 2003 the range is unlocked. I've asked the programmer to try your second saveas option. Maybe that will do the trick.

    I will keep you posted

  10. #10
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2003 / 2000)

    Even if you copy a workbook from a CD to the hard disk, it will still be readonly unless you specifically turn off the readonly attribute. The readonly bit is set when the file is written to the cd, and it is copied with the file back to the hard disk.
    Legare Coleman

Posting Permissions

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