protected sheet

In my old version of Excel for Mac, the enter and tab keys had the same function with the return key having a separate function. This was extremely useful for entering data into a protected spreadsheet. Each time the enter key was pressed the active cell would move to the next cell SKIPPING...

Recently I updated from 2004 to 2010 and have run into an issue with copying into a protected worksheet. There is a range that is a user input that must be copied in from another worksheet, but when the worksheet is protected the cells become locked as soon as copied. Basically I would like...

I've been trying to find a way to do ink annotations on a protected sheet in Excel 2007. I use a Windows XP Tablet PC. My reason for a protected sheet is that there are several formulas and format settings that can't be changed, with only certain cells free for inputting data. The...

Hello Saviours, Every time I protect a sheet, I can no longer sort any values in my tables. I check the box saying that users should be able to sort. But no luck. Even if I say we can do EVERYTHING to the sheet (and it's still protected) - it still says I cannot sort while the sheet is...

I am trying to sort protected cells in a protected worksheet. When you protect your worksheet, there is a checkbox that, if checked, apparently should allow users to sort the worksheet, but it doesn't matter whether or not you check this box and protect the worksheet. Excel won't allow you to...

I have a protected spreadsheet that links to another spreadsheet that is in the same folder (C:\example\master.xlsx and C:\example\subordinate.xls) I want to be able to use them both in any computer (that means, in any folder). For instance, I would like to be able to paste those two files in...

Afternoon, I have a piece of code that will shrink down the size of my spreadsheet from 12mb to 3mb. This code works but it will not run when worksheets are protected. Seems to point to: Else .Range(.Cells(myLastRow + 1, 1), _ .Cells(.Rows.Count, 1)).EntireRow.Delete .Range(.Cells(1...

Hi, I am trying to protect a worksheet, but still enable the "Group/Ungroup" functionality to work. I've managed to source the code for this from another forum - Code below: Sub ProtectAll() Dim ws As Worksheet sSheet = "Sheet7" For Each ws In ThisWorkbook.Worksheets...

I have created a worksheet that is controlled entirely by buttons and userforms. How can I protect it so nobody can change the worksheet name and/or alter the cells/rows manually? The userforms will change/delete/insert rows and information though...

Hi At our lab we use protected worksheets to calculate analytical results ranging from 0,00001 to 1000000. In order to allow the users to change the number of digits, that they want for a given set of results, a cell - e.g. A1 - is left unprotected for the entry of the desired number of...

I have an Excel 2007 document with various worksheets/tabs, several of which I would like hidden and password protected. I do want to present 2 tabs to the user, but hide the rest. Is there a way to hide tabs and create a password to view (or un-hide) the tabs? <?xml:namespace prefix = o ns =...

Hi How can I prevent users to hide/unhide sheets when my worksheet is protected Kind regards Al

I just ran into this issue now using excel 2007 and don't recall it being an issue with 2003. I have a protected worksheet and when I tab over a few cells and hit enter it takes me down one cell rather than to one cell down but in the same column as before. i.e. Before in 2003 if I started in A1...

anyone know how I set the attributes of a Protected Workbook ie SelectUnlockedCells=True SelectLockedCells=False InsertRows=True Martin

OK, so this is really puzzling me. I have only cells K1:AF1 locked and my worksheet protected. As expected, I cannot select these cells but I can select all the other cells. The problem occurs with navigating the worksheet, anytime I hit the enter key, the up key, or the down key; I end up in...

Hello! I have a Excel file (#1) with links to another Excel file (#2). #1 have protected sheets. I want to move #1 but then it´s not possible to uppdate the links between the files because of the protection. I have tried to open those cells where the links to #2 are located. But it does not work...

I have a protected worksheet that is distributed for data input. The data input area is limited to a defined area of unprotected cells. I would like to allow the end user the capability of creating a link within the input cells (currently can) and be able to update or change the link (currently...

I have the strangest problem. :confused: I have an excel form. A lot of different validations, VBA code and stuff. hverything works, however, i am stock on the easiest thing, that appears to be a bug in Excel. I am trying to protect a sheet. I specified which cells to be unprotected. However...

This may sound trite but I am having a problem with cell advancing when the worksheet is protected. Using the number pad to enter in information, if the worksheet is protected the enter key automatically moves the highlighted cell to the NEXT UNPROTECTED CELL instead of DOWN TO THE CELL BELOW...