Protection options in XP compared to 97

[Christopher]

To all,

I have created a document for our Sales team in MS Excel
XP and have protected certain cells and left some rows
unprotected in one workbook. I have chosen the option to
protect the cells and allow the users to be able to insert
rows. This works nicely in Office XP but users of Office
97/2000 are unable to insert rows.

Does anyone have any idea around this besides telling the
users to upgrade to Office XP?

Thanks and regards
Christopher

 

[Bill Lunney]

No direct way round this. The functionality simply isn't there in 97.

If the purpose is to stop the user from editing data once they have added it
and/or to stop them from touching existing data then how about...

Create a protected sheet which contains the data you want to preserve. Have
another sheet (or user form) where they can enter data. You then have a
process which copies new rows or whatever to the main protected sheet. If
you're going to use anything other than forms though it will get a bit messy
to code.


--

Regards,


Bill Lunney
www.billlunney.com

 

[Harlan Grove]

...
...

Does anyone have any idea around this besides telling the
users to upgrade to Office XP?

...

As you've already been told, no. Rewrite the app using Excel 97, and design to
its limitations unless it'd be quick & painless to upgrade ALL POTENTIAL users.

This is a PRIME EXAMPLE of why ALL companies should provide their developers
with the OLDEST in-use versions of ALL software IDEALLY on the OLDEST and
SLOWEST in-use hardware. If developers can get their programs to work under such
configurations, it's almost certain to work better/faster under any user's
configuration. Unfortunately, developers and IT purchasers usually sit too close
to each other.