LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
manxshaun
 
Posts: n/a
Default Allow users to edit range query

Excel 2002

If I set up an area, say c1:c5, all locked and then Allow users to edit
range and protect worksheet, I would expect an allowed user to be able
to double click on any cell in the range and input in it or move to one
of the allowed cells and input to it.

This isn't happening, double clicking on anywhere in the range defaults
to the first cell and you can only input there, doesn't seem to be any
way of moving to the other cells.

What am I doing wrong? ;-)

Regards Shaun

 
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
Cannot edit query. [email protected] Excel Discussion (Misc queries) 0 March 18th 05 07:42 PM
Protecting Workbook Paul Cooling Excel Discussion (Misc queries) 2 March 7th 05 11:55 AM
Multiple excel users can open the same file and edit at the same . Jeff Howard Excel Discussion (Misc queries) 1 February 18th 05 12:19 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM
Editing MS Query Patti Excel Worksheet Functions 2 December 2nd 04 01:31 PM


All times are GMT +1. The time now is 11:44 PM.

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"