 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007excel
How can you tell when an excel spreadsheet is locked. > How can you tell when an excel spreadsheet is locked. when you say locking, is it protecting or freezing?? I mean when a user tries to copy data from a cell and it wont allow them. Is there away you can tell if the hole worksheet is locked so a user cant copy and paste or do any work in it at all. The file is not a read only. >> How can you tell when an excel spreadsheet is locked. > > when you say locking, is it protecting or freezing?? You can see if sheet protection is enabled by looking at Tools>Protection. If "Unprotect Sheet" is available then the sheet is protected but you still won't know which cells are locked or not. Note: if the workbook is shared, this method is not valid. Shared workbooks don't allow sheet protection to be altered. If you want to see which individual cells are locked or unlocked you need VBA code. If you want code, post back. If you just want to make sure every cell is locked, unprotect the sheet and hit CTRL + a(twice in 2003) Format>Cells<Protection. Checkmark "locked" Then re-protect the sheet. Gord Dibben MS Excel MVP >I mean when a user tries to copy data from a cell and it wont allow >them. Is there away you can tell if the hole worksheet is locked so a [quoted text clipped - 4 lines] >> >> when you say locking, is it protecting or freezing?? If you wish to see what cells are not locked, without using VBA... Select the whole spreadsheet. Use Format -> Conditional Formatting Set condition as 'Formula Is', enter the formula =NOT(CELL("protect",A1)), set the format as a pattern say red. Ed Ferrero www.edferrero.com
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.