View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liz Liz is offline
external usenet poster
 
Posts: 8
Default protection / edit ranges

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.