LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ket
 
Posts: n/a
Default Cell Protection Issue

Hi,

I am using Excel 2000. I have created a worksheet in which some of the
cells have validation lists. I have protected the worksheet and
unprotected the Validation cells so that when a user opens the sheet
and clicks one of the validation cells, a pick list will appear. This
works fine for myself and my collegues in my department.

I have emailed this workbook to an external agent to look at. He is
running Excel 2002 and is telling me that once he has opened the
spreadsheet and attempts to choose one of the validation cells, he is
presented with the ' The cell or workshhet you are trying to change is
protected....'

Has anyone seen this before or able to suggest why it i happening?
I am hesitant in providing the 3rd Party agent with the unprotection
password.

TIA

Ket
London, UK
 
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
Data validation, cell protection or other method? KG Excel Discussion (Misc queries) 5 June 17th 05 05:22 AM
protection issue Peter Mitterboeck Excel Worksheet Functions 1 March 16th 05 03:52 AM
Cell Protection Color Kmagg Excel Discussion (Misc queries) 4 February 10th 05 05:46 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
Cell Colors and Sheet Protection cincode5 Excel Discussion (Misc queries) 1 December 3rd 04 10:39 PM


All times are GMT +1. The time now is 08:59 AM.

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

About Us

"It's about Microsoft Excel"