LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allow users to edit ranges for VBA objects Jeff Excel Worksheet Functions 6 June 29th 06 11:08 PM
Add Permission did not work in "Allow User to Edit Ranges" hsinlin58 Excel Discussion (Misc queries) 0 May 22nd 06 03:10 PM
Validation protection with named ranges Ben H Excel Worksheet Functions 1 March 17th 06 03:49 AM
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
allow users to edit ranges neeraj Excel Discussion (Misc queries) 2 September 23rd 05 02:48 PM


All times are GMT +1. The time now is 02:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"