1. W

    Protected sheet disables macro buttons

    I am working on an Excel form to allow users to submit data about decisions made and topics covered in meetings as part of a larger project. I will have a lot of different people entering data in this Excel file, so I want to lock as many cells as I can to make sure things aren't accidentally...
  2. M

    row protection based on specific cell

    Como protejo automaticamente uma linha com base em uma célula? Exemplo: se você inserir um valor na célula E1, ele protegerá automaticamente as células à esquerda da linha, D1, C1, B1 e A1 E o mesmo se aplicaria às linhas seguintes, se você inserir um valor na célula E2 ele protegerá...
  3. R

    Need to protect formulae but retain function

    Good afternoon everyone. I have an Excel order form we use with our customers for them to place small orders but I need to protect the formulae while retaining its functionality. Each cell in column C has the =sum(A2*B2/1000) to calculate the correct meterage from the quantity and length...
  4. H

    VBA: auto-wipe all data when date is reached

    Is there some VBA code that can password protect a workbook when a certain date is reached so the data cannot be viewed or edited by anyone without the password?
  5. K

    Unprotect and Refresh Pivot Tables in a Data Model Where the Data is Being Used in Multiple Tables

    I have multiple pivot tables that are part of a data model that I want to unprotect, refresh, and reprotect. Below is the VBA Code I have so far. It isn't working. Excel gives me a message "That command cannot be performed while a protected sheet contains another PivotTable report based on...
  6. C

    Auto re-protect

    Hello! I am fairly new at messing with Excel beyond the very basics. I have a schedule at work that I would like a specific worksheet to require a password each time it is opened. Sadly, the problem is that using the build in protection in Excel, some of the individuals who require access to...
  7. R

    Prevent changes to specific worksheet (VBA)

    Hi, I would like to disable the option to delete, move, copy or rename one specific worksheet in a workbook, regardless of the activated worksheet in the workbook. I cannot protect the workbook structure, because I want to still be able to delete other worksheets in this workbook without the use...
  8. F

    VBA Script to automatically apply Password to Workbook when closing, prompt user for PW when opening and setting to read-only if input incorrect.

    Hello Everyone Been scouring these forums for a few days before deciding to make my own account... There's been many topics that come extremely close to what I'm looking for, yet none have been the exact same to my knowledge. So, I'd like for the entire workbook to be Password protected upon...
  9. M

    Unable to protect sheet

    On filling in: I am met with: Which never dissapears and excel becomes unresponsive and must be force closed. O365 with Kutools but same behavior in safe mode.
  10. H

    Auto-Protrect Sheets in Shared Workbook?

    Hello all! Is it possible to have a workbook auto-protect the sheets, even as a live (auto-save) file on Sharepoint? Before uploading this shared workbook to Sharepoint, we had macros set to automatically re-protect all sheets in the workbook. I'm having trouble working out if this function is...
  11. S

    Button Triggered Allow Edit Range with password with different password for each cells

    Was planning on making a button that utilizes the allow edit range feature which once clicked it will. 1. Lock all cells with value. 2. Cell with value will each have different password. and the password will be the Queue ID (Example - row 2 will only be editable if keyed in password T13P001...
  12. M

    Allow Filtering in One column in Protected Sheet

    Hi all, I have a protected sheet with a bunch of columns, and I wanted to allow the user to be able to filter only one of these columns (they can filter their name). Is there any way to do this?
  13. S

    How to hide VBA Code on a Protected Sheet?

    I am using code to add a double line that requires me to set the same password as the password to protect the sheet. And I don't want someone to be able to view the code on my protected sheet. How do I do this? Also, I don't want to hide the sheet, just protect it. Here is the code, if needed...
  14. L

    Password Protect Tabs (or only able to view a certain tab)

    Hello all! New user to Excel (previously Google Sheets). First of all, I have tried to check other posts that are similar and google, but don't think I have found exactly what I am looking for as each seem different. I currently have a spreadsheet to review Pay Rises, Overtime etc. I have...
  15. S

    unshare excel workbooks Anonymous persons

    This is my first Post/question. I've a workbook and lets say I shared the same with group of 30 more people. I want the workbook to be accessed by only the group of 30 people. If the same excel shared out of the group, it should not be accessible. Else, I want the workbook to be accessed by...
  16. s_macloskey

    Add +1 to a cell value (plus complications!)

    Good morning all, I have another VBA/AcitveX/Button query that I hope someone can help me to solve! Also please forgive me as I don't 100% know the QUESTION I am asking, I just know the result I am after. (I have also have to redact some of the information becuase of where I work.) Context...
  17. s_macloskey

    Protect/Unprotect worksheet VBA BUTTON?

    Hello all, context: I have created an employee holiday/leave sheet on (we use Excel 365) I have made a sheet for each month and they require 'protecting' and 'unprotecting' seperately/individually - with a password query: My team is not so computer literate so, I need to create an easy to...
  18. A

    ActiveWorkbook.Protect issues/questions

    Part of my Macro is protecting my workbook. If I run the same macro, with the workbook protected, it will unprotect my workbook even though there is nothing in the code telling it to do so. Is this a common thing with protecting workbooks in VBA? Below is a sampling of the my code...
  19. O

    Hosting a password protected excel sheet online

    For this game I play I've made an excel workbook to simulate ingame battles. It works quite neatly, and I would like to share it with my team. However, I would prefer to be the only one to have this workbook hence when someone leaves the team I'd like to retract access. Is there some way to...
  20. D

    Tipping Competition

    Hi, I am creating a 'Tipping Competition' and I want to make the Worksheets so that after a certain time nothing can be edited by Tipsters. I have managed to hide the Ribbon (so they can't unprotect the Sheet) and I can lock and protect the Sheets as needed. What I can't do is work out how to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back