View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default protection / edit ranges

This level of protection was added in xl2002.

What version of excel does she run?

Liz wrote:

Excel 2002

I created a workbook with multiple sheets. I turned on protection for each
of the individual sheets, and used the "Allow users to edit ranges" to
define sections, and set the permissions to "Everyone".

It tests perfectly on my computer, but when I emailed the sheet to another
user, not so. The user saved the sheet in her own folder. The ranges I
defined cannot be edited on her copy.

Suggestions? Thank you.


--

Dave Peterson