protected sheet

  1. 1

    Excel table not expanding with new data

    Hi, I created a table in Excel that was working perfectly for other users to enter data. Now it is no longer expanding automatically when new data is entered in the next available row. I have tried everything including checking the auto format as you type in options (it's Excel 2010). I had the...
  2. N

    Sort and Filter on Locked Cells

    Hi, I have a worksheet that I would like users to be able to sort and filter the contents of, but half of the columns are formulas that I would like to keep locked and half are open for editing. When I have the cells with formula 'locked' (via formatting the cells) the sort function doesnt...
  3. I

    Spell check either Active X text box, text box or merged cells in excel 2016

    I hope someone can help me. I have a protected workbook with protected work sheets (2016). I built the spreadsheet with merged cells for user comments, but have now been asked to allow spell check in the comments field. In the example below I would need a text box/merged cell from b2:e3 (with...
  4. M

    Getting Data From Last Years Accounts Workbook

    Hello all, I have had some great tips etc. from you Excel Experts and am hoping for more. You recently solved my 'INDIRECT' question which works well but now I am looking to copy 'cars in stock' data from a sheet in last years workbook into a stock book sheet in this years workbook. I would...
  5. P

    Select unlocked cells in a protected sheet.

    Me again. A slightly more challenging one this time. I have a worksheet with multiple formula some on hidden rows, all nicely laid out and formatted to make an easy to use standard report. I have the sheet protected from accidental editing by well meaning colleagues. All good! I want to...
  6. N

    VBA- Filter on Multiple Drop Down on Protected sheet

    Hello, I am having a difficult time with a VBA code for allowing filtering capabilities on a protected sheet with multiple drop down. The sheet itself allows users to select multiple items from drop downs on columns 12-16; however, users have been unable to use basic filtering, sorting, and...
  7. G

    Select Quarter for COUNTIFS

    My database has a column for initial date from which Iidentify the YEAR and QUARTER. I use the COUNTIFS function where one criteriais QUARTER and the range is 3 for Q3. IfI want to look at the data for another QUARTER like Q1 to Q3, I have to changethe range to =<3. The report has over30...
  8. A

    how to insert row and copy down formula in a Protected Sheet

    Hi, first post on here so please excuse! I am, and have been for quite some time, trying to set up a spreadsheet to be used by a wide range of users (many with very little excel knowledge) which has a great deal of code and formula within it. I have therefore password protected the sheet to...
  9. O

    Disabeling/enabeling pages protected workbook

    HelloHi allNew on the forum here. Looking forward to being part of the community. I have a problem that I have been struggeling with for some time. I have a proteced workbook consisting of 1 sheet and 4 pages in that sheet. The problem is;The users using the sheet may only need page 1 and 4 so...
  10. A

    Macro allowing both column grouping and row hide/unhide functionality in a protected sheet

    I've been struggling to find a macro code that allows both column grouping and row formatting (hide/unhide in my case) in a password protected sheet. The macros that I've used to allow column grouping work for that purpose, but then seem to disable the ability to allow row/column formatting when...
  11. V

    Excel 2010 - Collapse/Expand cell when Sheet is Protected

    Is there a way to allow a sheet to Collapse or Expand Rows when the page is protected? Apparently selecting Format Column/Rows in the check boxes does not allow this once the page is protected. I have a gorup of protected cells on the page, but need to allow the users to group collapse or...
  12. D

    Excel VBA hide rows from range with value at multiple protected sheets

    I have tried finding code for hiding rows from range with value criteria, with applying it to multiple protected sheets. Could someone help build the right code.Original code as following (i'll explain what i would need after the code): Sub CreatePDF_ERIKHONOKRISSEPETE() sheetname =...
  13. A

    Unhide multiple groups of rows, one group at a time

    I am attempting to use one macro to unhide a select group of rows in a locked worksheet. I have a VBA code but it only unhides 1 row at a time, and the one who wrote it isn't around to fix it. I am looking to make 1 button that when clicked, will unhide rows 110:130, then if pressed again will...
  14. B

    Protected Sheet Hacked

    I have a program that depends on VBA and cell formulas that I send to customers for projections. We do not want them to have access to either the formulas or the VBA. I feel the VBA is safe (enough) with password protection. However, even with sheet protection, one of our customers sent back a...
  15. M

    Send cell by email - protected sheet

    I have a worksheet that has cells/formulas protected so that the data stays accurate. I left certain cells unprotected for others to access and fill in their information. The problem is that when trying to send the worksheet as the message body only by email, not an attachment, an error pops...
  16. J

    [vba] cannot hide/unhide rows when sheet is protected

    Hi, I have this code in my module Private Sub Boys_Click()If Boys.Value = True Then Rows("13:57").EntireRow.Hidden = True Else Rows("13:57").EntireRow.Hidden = False End If End Sub However, my problem is whenever i protect the sheet it doesnt allow me to proceed(debug mode) since i am...
  17. L

    Protecting Top Row Only in a Worksheet

    How can the top row of a worksheet be protected/locked? We have a status log being accessed by multiple people who need to be able to add/delete rows. People keep putting typos in the top row however, which contains our column titles - so I want to find a way to lock that down. I have tried the...
  18. G

    Unable to unlock chart within a protected worksheet

    Understand how to lock and unlock cells, how to protect and unprotect worksheets. When sheet is locked, I need to allow the user to select the generated chart, and copy it for use elsewhere. Seen other posts-- Format Chart, Properties, Unlock. But, when the sheet is unprotected, I select the...
  19. R

    Others can't use groupings in my protected sheet

    Hi - I am using Office 2013 and have a protected sheet where I would like users to still be able to open/close groupings. I have used the code: Private Sub Worksheet_Open() With Worksheet ("Europe") .Unprotect Password:="PW12" .Protect Password:="PW12", Userinterfaceonly:=True .EnableOutlining...
  20. F

    Pivot Table Change Filter on Protected Sheet

    Hi there, Would anyone know how to allow users to adjust a filter for a pivot table (external data source - OLAP cube) on a protected sheet? When I try to change the filter I get the following error: That command cannot be performed on a protected sheet because the source for this PivotTable...

Some videos you may like

This Week's Hot Topics

Top