protect

Hi, I have a file which will be distributed to various depts which contains only a few columns of sensitive information. I need to hide these columns but also allow that the entire sheet be pasted over, as this file will be updated monthly. The team updating this particular sheet are not excel...

Hi, Is there a way to protect the formulas in the whole workbook without having to protect every single sheet one by one with the "protect sheet" function? :confused:

Hello All, I have a workbook, which is placed in a shared drive, as i now need to update the work allocation & for each team member in different sheets under there name. Help required; 1. Need to protect the columns in all the sheets of the team member & allow few columns AB to AZ to allow...

Hi all, I need to protect a sheet and let the user to expand and collapse rows and columns. I also need to save this WB in .xlsx (not in .xlsm) so I cannot use macros (as far as I know). Is there a way to protect the sheet by the option Review/Protect sheet and let the user expand and...

Hi everyone, I want to protect sheet, cannot unhide sheet or set password for unhide sheet (only specific sheet) anyone who can know code in VBA Thank you in advance for your respond :)

I have a spreadsheet that I locked down with a password so users couldn't accidentally do things to wreck it. My supervisor now wants to be able to edit it and I have tried to comment out all the sections of protecting the worksheets in the project and it still is protecting itself after I click...

I'm managing a workbook that includes payroll information, which contains confidential information like hourly wages. Each payperiod I reset the workbook and advance the calendar dates so my assistant can enter in the hours worked for each employee. Each employee has their own worksheet. All the...

I have a spreadsheet with dates in R3:CE3 . I was looking to have this auto lock the cells from edit anything two days prior to today's date. Columns A:Q are protected when I protect the sheet. R:CE are the only columns you can edit. Hopefully someone can help me out on this. Appreciate the help.

Hello, I have a macro that works as needed. The sheet has form buttons I want to protect but when I unlock cells A10 to M50 and protect the sheet I receive error 1004 saying a cell its trying to write to is protected and read only. I'm not sure what I'm missing. Any help will be appreciated...

I have sheet "A" with shapes which updates when changes is made in sheet "B". I need to protect sheet "A" since no one touch the shapes. The problem is that since sheet "A" is protected, updates fail. I need a macro that unprotect the sheet, then update and then protect the sheet again. Is this...

Hello - I am new to writing macros. I know how to write a macro to protect ranges but I need one where I can protect certain columns based on the current month. For example i have an excel file with a column for each month of the year. For Jan I need to protect just the one column for Jan but...

Hi Folks! I am hoping someone can help me out. I have a workbook with 84 tabs which all tabs need to be password protected. I came up with the code below but then I realized that several of the tabs require various other formatting requirements other than AllowFormmattingRows:=True. For...

Hi! Plenty of threads on this one, but I'm still confused. Whenever I protect the worksheet, possibility to refresh a table is disabled (external data connection to IBM DB2). Shouldn't be a problem to overcome with VBA (add Unprotect & Protect the sheet to the code), but instead of pushing a...

Please help me out with VBA code, if I enter “ok” any ware betweenE1:E500 entire row should be protected. Eg – If I enter ok in “E2” then “A2:D2” should be protected <colgroup><col width="26" style="width...

I am using the following VBA to copy a row complete with all the Formulas, but my users keep *accidentally* deleting the formulas so I want to protect Col B:K Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True...

Good day all. With the help of many of you on the Forum, I have been able to create a workbook that tracks the activates of my motorcycle club. In addition to the tracking worksheets, there are computations creating totals and percentages of activities. I am now ready to make this workbook...

Hello, I am trying to protect a sheet such that the options Select Unlocked Cells and Use PivotTable & PivotChart are enabled via VBA. I'm not finding much success on keeping these features on. Is there anyone that can point me to the right direction? Thanks.

Hi Excel Guru's! I've just created an awesome too for my department using Excel. Now I need to protect all the intricate an delicate formulas, that's where you come in.. Workbook details: There are 11 tabs 'feeding' off of a main data source. In that 'main' tab I need to lock or password...

Hi! Is there a way to leave some cells editable, but then lock the entire worksheet at once. I can only seem to do this a sheet at a time (Protect Sheet). I tried Protect Workbook, but this didn't lock the cells. Given my file has a lot of sheets, I have my fingers crossed that there is an...

Hello Is it possible to apply a vba protect multiple sheets at once? (I have the VBA already - kindly supplied on this site) Thank you