please please say it isnt so!!!
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: please please say it isnt so!!!

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Does ne one know if MS Excel 2002 security features will work in MS Excel 2000 (you know where you can select what the user may do, such as selecting locked and unlocked cells). If i have set it so that unlocked cells cant be selected (until a macro allows it) will Excel 2000 allow the 2002 version file to open and run! im supposed to be testing it on a 2000 system tommorow and am getting really worried!

    does ne one know? i mean the 2002 version gives an option that lets you save it as a workbook that can be recognised back betweeen 2002-95 (or so it says ne way) is this true in all cases - if i have applied features like the allow the user to select locked cells or dont allow the user to select locked cells will this mean it doesnt work in excel 2000!

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Email and I'll test it NOW.

    Dreamboat@TheWordExpert.com
    ~Anne Troy

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-31 16:40, Daniel Cremin wrote:
    Does ne one know if MS Excel 2002 security features will work in MS Excel 2000 (you know where you can select what the user may do, such as selecting locked and unlocked cells). If i have set it so that unlocked cells cant be selected (until a macro allows it) will Excel 2000 allow the 2002 version file to open and run! im supposed to be testing it on a 2000 system tommorow and am getting really worried!

    does ne one know? i mean the 2002 version gives an option that lets you save it as a workbook that can be recognised back betweeen 2002-95 (or so it says ne way) is this true in all cases - if i have applied features like the allow the user to select locked cells or dont allow the user to select locked cells will this mean it doesnt work in excel 2000!
    If you mean;

    ActiveSheet.EnableSelection = xlUnlockedCells 'xlNoSelection


    Then this feature is supported in excel 97/2000


    Kind Regards,
    Ivan F Moala From the City of Sails

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i havent used any of the new features of Excel 2002 such as the smart tages or formula watches (i think there new arent they?) so if i save it as an excel 2002-95 workbook it should probably work fine in Excel 2000 - he says in a very hopeful voice!

  5. #5
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-03-31 18:48, Daniel Cremin wrote:
    i havent used any of the new features of Excel 2002 such as the smart tages or formula watches (i think there new arent they?) so if i save it as an excel 2002-95 workbook it should probably work fine in Excel 2000 - he says in a very hopeful voice!
    If you have done the aboce then YES it should
    work......


    Kind Regards,
    Ivan F Moala From the City of Sails

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com