protected

Hello, I am sure this is an easy question but would anyone know why I am getting a 1004 Runtime Error in my Code after I protected the Worksheets from the review Tab? The code works fine when the sheets are unprotected, but I need to protect the worksheets so users can not adjust the formulas...

I have a worksheet that is protected and want to run a macro that clears certain cells after use. However, it won't run since the sheet is protected. I don't want to unprotect the sheet due to a number of formulas that are being utilized.

Good Evening to All... Can a workbook be protected from being copied ??? Thank you.

I use the following code to open a workbook to pull information, this workbook as been password protected .So I need to alter the code to include the password. Range("A85").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True I have searched the internet, but cannot...

Hello Masters of Happiness, I have learned tons on this site without ever asking a question, but today I need help!! I have a protected worksheet, and users are to access certain cells. Those columns that are most relevant are displayed, while less relevant columns are grouped and collapsed. I...

http://tinypic.com/r/amdso7/9 My code is only working when it is unprotcted,i wanto work my code when it is protected i have added my macro to 2 pictures 1 picture to add columns 2.Code not working properly iam attaching here with image which is protected. Sub addcolumns1() Dim numcol As...

I tried finding an answer but couldn't so I hope this is not a duplicate of a post with an answer. On a newly created sheet when you tab across and then finally hit "enter" the cursor goes to the next row and goes to column A (first column in my sheet). But, on my protected sheet when I hit the...

Hello I am looking for a vba code to allow a user to enter the value for the range of cells to protect on a worksheet. Ideally i would like it that when i run the macro then a message box would pop up to ask the user to enter the cell range values then to confirm and the cell range to be...

I had used below code given in some of the forum and it does the needful very well except when the sheet is locked and password protected. Can anyone give a workaround for the same? Private Sub Worksheet_Change(ByVal Target As Range) 'Does the validation range still have validation...

Dear all, I am having one excel file with vba in which some cells are protected (white) and others are unprotected (sky blue) within a specified range (print area) I want to take screenshots by double clicking on each protected cells in the range and which leads to popup msg of protected...

I am attempting to copy and paste a protected sheet so I can make my own modifications. I am able to copy and paste the column width but how do I do the same for row height?

Hi, is there a way to allow users to operate a data filter when the entire worksheet is protected ? The intended users will not be privy to the password. Kind regards, Chris

My excel workbook is password protected. And file has macros but my macros are disable when the workbook is password protected. Please helm me to fix the problem. And show me the setting. Thank you.

I have a textbox (VBA shape type 17) embedded in a chart embedded in a worksheet that is protected: Sheet11.ChartObjects(1).Chart.Shapes(1) I want to assign calculated text to the textbox using VBA. With the worksheet protected, I can successfully set the text in Excel 2016 using this (and...

Hi, after searching the web and testing VBA codes, I've become stuck... I have a Cell Range - E8:J27: where all cells have a fill color of RED, and can change to either WHITE or BLACK which is determined by conditional formatting. For the desired outcome I am not sure if the cell range...

I have tried to block just a few cells with formulas in a sheet leaving free the rest of the cells to be filled by variables if needed, I followed the Microsoft title "Lock or unlock specific areas of a protected worksheet" with NO success I wonder what I did wrong this is what I did: I...

HI folks, I have a protected spreadsheet which has every second row editable. At the end of the year I want to be able to delete all of the information from the editable rows of the sheet. When I filter on the editable rows, select all and press delete, I get the error telling me the sheet is...

Hello everyone! I have been working on an Excel spreadsheet for a master thesis, and this is my first time going around and using VBA. What I am trying to do is have each specific sheet in my workbook be protected against accidental changes of some cells. Therefore, I am running this code on...

Hello, I'm having an issue that I hoping someone can help me out. I've posted on this issue before but I cannot seem to make it work. Here is the URL to the other string: https://www.mrexcel.com/forum/excel-questions/1062784-protect-workbook-structure-issue.html#post5109213 I have a...

Hey everyone, I have a sheet that is protected that we use internally to calculate funds for customers. The sheet itself undergoes some changes for each customer, including deleting rows; I have tried macros to just protect as data is entered or on save, but there are too many variables that I...