protection / edit ranges

  • Thread starter Thread starter Liz
  • Start date Start date
L

Liz

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.
 
That was it - she was on 2000 - upgraded her to XP with the rest of the
office, and we're all set! Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Protect the Whole Workbook and Allow Range Edits 2
Dynamic Protected Range? 1
Protected Worksheet Tab Order 1
Protect but Allow Edit Ranges in Multiple Sheets 6
Protect sheet with permissions? 3
Refresh Pivot table data in protect sheet 2
Method for protecting cells which still allows quick editing 2
Code to format cells on several worksheets 2

Back
Top