protected sheet

  1. N

    Set wsheet protect to Null

    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...
  2. T

    Protecting a worksheet

    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...
  3. M

    Changing decimal numbers in protected sheet

    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...
  4. M

    Password Protect Worksheets/Tabs

    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 =...
  5. already

    hide en unhide sheets

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

    Password protected sheet issues

    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...
  7. M

    VBA - setting attributes of protected workbook

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

    Navigating with protected worksheet.

    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...
  9. K

    Move protected Excel file with links

    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...
  10. M

    Protected Worksheet - need to update/change links

    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...
  11. M

    Unprotect cell is STILL protected.

    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...
  12. W

    protected cells acted differently on Mac excel 08

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top