protect

Hello, I have the following code which i have to protect my workbook and allow filtering. Sub ProtectSheets() Dim wsheet As Worksheet For Each wsheet In ActiveWorkbook.Worksheets If wsheet.NAME <> "TB - EPM" And wsheet.NAME <> "ACT - GLORY" And wsheet.NAME <> "ACT - BARC" And wsheet.NAME <>...

Hello! I've had an issue plaguing me for a while now; Most of the time, when I open my workbook, the highlighted border around my active cell disappears. I suspect that it is caused by my workbook_open() code, but any time I try to debug it, the issue goes away. Whenever I open the...

I'm having some trouble with the command button code below when I protect my workbook. I can protect the worksheet the button is on and lock it down so everything is tight, but as soon as I protect the workbook, I get a "Run-time error '1004': Method 'Visible' of object'_Worksheet' failed...

I used this VBA application to add the date when I update a cell. But now I can't protect the sheet? If I protect the sheet the VBA application does not work? Is there anyway to protect the sheet and use VBA? <code class="vb keyword" style="white-space: nowrap; padding: 0px !important...

Hi, I have a wb for data entry. On one ws the data is entered in a table and at the end of the day copied and saved to another ws in the wb with a macro. I would like to protect the data entry ws, but if I do my table doesn’t expand anymore.... Is there a workaround for that? Thank you!

Hi! Running out of answers on this one. I need to run VBA to select and copy some data from the Excel worksheet to be available on the clipboard. The sheet is also protected and I need to Unprotect & Protect sheet in the start and finish. Although it works fine when done manually, when...

Hi all, I am now working on a data collection sheet and would need some helps from experts here, please kindly gives some advises. I create a worksheet and want others to fill in structure design parameters (length, width, distance between two objects, etc). To better explain where I am...

Hi everyone, I have a workbook with VBA code. One of the worksheet is Proteced and the VBA code is Protected. The VBA code is unprotecting the worksheet and afterwards protect it again. The programm is loading data from an external source (*.txt files). Sometimes the Excel file crashes due to...

Re: Locked cells are still editable even though not in "Allow user to edit ranges"-range. I have same issue. I tried many times to Format cells > Protection > Check "Locked" box, but still allow me to edit. I want to ... A) Password protect ranges $A:$I, $O:$P, and $J$1:$N$2 so only I can...

How do you protect single cells on a sheet?:confused:

Hi If I click on Share Worksheet then Protect workbook/sheet will be grayed out. so I should first pportoct workbook/sheet firs then share. What is the idea behind this sequence.? Thank you very much

Dear Friends Can anyone please help me to protect my print range in attached sheet. In attached sheet, I have selected range from A1 to G49 for printing but some of my team members can change this printing range and then print. Can anyone please help, how to protect it...

Hi Friends I have a protected sheet with footer. I have shared this sheet with my team members, but I have observed that they are able to change/delete the footer, even my sheet is protected. can any one please give me the solution, how I can protect my footer as well. Regards

I know how to password protect an excel file, however, is there a way to password protect a file folder with excel files in it? Say I have hundreds of documents in a single folder that I need secure, however, I don't want to go back in and password protect every one of them. I know this is not...

Hi everyone i have created an Excel user form but data don’t need to store in any Excel workbook. All I want to do is to protect my userform code from viewing or editing by users but allow users to input data in the user form. Please could anyone tell tell me how can I protect the userform...

Hello- Not sure this is the right spot for this one... I have issues with coworkers uploading an Excel file that I have password-protected into Google Sheets, which removes all of the protections I have created (sigh), and allows them to see hidden sheets, etc. I am wondering if there is some...

Having trouble finding VBA code that addresses a table instead of just a pre-selected set of cells. I have a large table that will continue to have rows added to it as users add new entries - so I need this to be dynamic rather than selecting a range of cells (ie, I don't want this to be...

I have a work book that has multiple Sheets in it (32sheets total). Now each one of them have a protect sheet with password to unprotect. They all have the same password. My question is there any way to protect the entire work book with the same settings(Select Unlocked Cells, Format Cells, edit...

Hello Every1. 1) I would like to ask that is there anyway other than macro to protect the sheet with password. 2) Also if i can hide the used formula. For Example :- 1) I have all my main working data with infor in sheet1 and i am using the data with respective info in sheet2 & sheet3...