please please say it isnt so!!!

Daniel Cremin · Mar 31st, 2002, 05:40 PM

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!

Anne Troy · Mar 31st, 2002, 06:54 PM

Email and I'll test it NOW.

Dreamboat@TheWordExpert.com

Ivan F Moala · Mar 31st, 2002, 07:00 PM

Quote:

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

Daniel Cremin · Mar 31st, 2002, 07:48 PM

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!

Ivan F Moala · Mar 31st, 2002, 07:59 PM

Quote:

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......

Mar 31st, 2002, 06:54 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Email and I'll test it NOW. Dreamboat@TheWordExpert.com __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 31st, 2002, 05:40 PM	#1
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	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!

Mar 31st, 2002, 07:48 PM	#4
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	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!