Can I lock info in Excel 2003 and users in Excel 2000 enter info?

Can I lock info in Excel 2003 and users in Excel 2000 enter info?

Post by TWltbXNhb » Fri, 09 Sep 2005 05:45:04


I am trying to lock some information in Excel sheets while leaving other
"open" so other users can enter data. In my office we are using Excel 2003
but several of the receipients are using older versions of Excel. When I
tried to enter data using Excel 200 it only worked in some of the sheets and
I am worried that this is not a supported function in previous versions. Does
anyone know if this is the case and if so, is there anyway around it?
 
 
 

Can I lock info in Excel 2003 and users in Excel 2000 enter info?

Post by Dave Peter » Fri, 09 Sep 2005 08:12:58

Allowing users to edit ranges was added in xl2002--so it doesn't exist in xl2k.

You could unlock all the cells that anyone can change.

Or maybe provide some kind of macro that unprotects the sheet, locks/unlocks
cells based on a user, and then reprotect the sheet. (Doesn't sound like fun to
me.)

On top of that, worksheet protection is easily broken. Macros can be turned
off. It would be a pain.



--

Dave Peterson