LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default Locked cells in Excel 2000

Hi

In Excel 2003 when you protect a worksheet you can deselect "format locked
cells" so that when you try to click on a locked cell in the spreadsheet you
can't.

Can you do this in 2000?

Reason is I have set-up a tab order in my worksheet so that users can easily
navigate to the data entry cells however if I accidently click out of the tab
sequence into a locked cell it looses the tab order - I know I can reselect
the 'named range' however a user won't?

Thanks and Merry Christmas. Silena
 
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
How do I sort locked cells in Excel? Cathy Excel Worksheet Functions 4 August 9th 06 04:51 PM
Excel locked cells Dave Semple Excel Discussion (Misc queries) 1 February 7th 06 07:06 PM
Put comments on a locked spreadsheet even though cells not locked RDP Excel Worksheet Functions 1 September 11th 05 11:59 PM
unlocked cells in excel 2000 now locked when opened in 2003 why? GallanH Excel Discussion (Misc queries) 4 August 31st 05 10:03 PM
All Cells in Excel are locked, what's wrong? Samuel Excel Discussion (Misc queries) 6 July 18th 05 12:31 AM


All times are GMT +1. The time now is 04:04 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"