Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 345
Default Something "Odd", Sheet Protection, Locked Cells

In my application I've been able to lock and unlock cells thru VBA, and
protect and unprotect worksheets just fine. The postings I looked at don't
seem to cover my situation below.

Today, when testing, I manually UNPROTECTED the worksheet.
Using the right arrow key I tried to scroll to a cell at the right edge of
the screen, I could not "get there". The cursor would only go to the
normally unlocked cells.
I double checked the sheet protection under "Tools" and the menu said
"Protect sheet" meaning to me that the sheet was NOT protected. In the
application when I protect the sheet, I enable only selection of UNlocked
cells.

After a couple of head scratchings, on a lark I saved and closed the
workbook,
opened it again, and was able to get to the cell I wanted. NO other settings
were changed or macros were run.

What's up with this?

thanks,
Neal

--
Neal Z
Reply
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 "List" to work in a locked sheet Ken Curtis Excel Worksheet Functions 4 September 7th 08 04:53 PM
Protect sheet unchecking "Select locked cells" has undesiredresults wal Excel Discussion (Misc queries) 1 September 1st 08 03:28 PM
sheet protected but cells "cleared of all" become locked Glen Excel Discussion (Misc queries) 4 August 8th 07 10:33 PM
Stop users from accessing "Protection" option from "Tools" menu I Believe Excel Programming 2 December 19th 05 02:44 PM
Protect shouldn't default to "allow users to select locked cells" JudiMicro Setting up and Configuration of Excel 0 November 18th 05 05:00 PM


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