protect

I have a vba which creates a new worksheets whose name is dependant on a cell value. At the same time it also created a PDF file of the same sheet. What I want it to do is also protect the newly created worksheet only. I have tried a few things to no avail. This is what I have so far Sub...

Chase Credit Card issued this announcement: Please update your browser.We'll stop supporting Internet Explorer® soon. Choosing another browser will also help protect your accounts and provide a better experience. Update your browser I would prefer to use Chrome ver. 77. Any advice?

Hi Is There anyone with experience of the software XLS Padlock (copy protect ). I am looking for a good way to copy protect my worksheet. Or is there any other software to use. Best regards Bengt

Hi Is there anybody out there who have tried XLS Padlock software to copy protect a Excel workbook.

Hey everyone. I'm getting close to being finished with a Macro-Enabled Excel workbook I've been working on for a while now. I plan to release it publicly, but do not want anyone to be able to see my VBA code. I know I can password protect it, but I've read that it's fairly easy for someone to...

Hi I know how to protect workbook in vba using workbooks(1).protect workbooks(1).unprotect What I want to do is to ask user this question: do you want to protect workbooks? yes/no If user say yes then I do wrokbooks(1).protect If user say no then I do workbooks(1).unprotect Any idea how...

I know how to protect a worksheet in a macro and also protect a workbook in a macro. But I don't know if it is possible to protect a workbook in windows. Let me explain. When I open up say drive F:\... on my flashcard, I see my workbook which I will call book1.xlsm. I want to be the only...

Hello, I would like to protect 3 columns using VBA. Protection should go as long as there is data. I measure the end of my data in column A and to find the last row I use: LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row Now, to protect 3 columns I used this code, but it doesn't work...

Hi, I want my excel to hide and unhide a row when i select an option from my drop-down list but it is not working. My excel sheet needs to be protected and certain areas need to be locked including part of the row. Here is the code: Private Sub Worksheet_Change(ByVal Target As Range) If...

Hi all, I have a spreadsheet with macros that I wrote. I have to give it to some colleagues and need to protect the sheet. When I protect it normally it makes the code not work. Has anyone protected a macro enabled worksheet? Thanks

I've used Excel for years, but have never run into this situation. I have an Excel spreadsheet I've created for my fellow workers to use to select items and then the sheet will do the calculations. All of my formula cells are protected, and the "fill in the blanks" cells are unprotected. I've...

Good day all. I have a spreadsheet with 80 (and growing) tabs. When this file is distributed, I would like all tabs to be protected with a password. I have VBA which does this: Dim wSheet As Worksheet Dim Pwd As String Pwd = InputBox("Enter your password to...

Hi all SITUATION: I have several individual workbooks for data input. 1 formula and some data validation. These have been combined into one table through power query which forms the 'source data' for another worksheet where the user inputs a criteria and the result is all the relevant data rows...

I have a workbook that I have been locking cells and using a password to protect. Recently, I was not able to unprotect the worksheet. Kept receiving the message that the password was incorrect. I believed that I was using the correct password. I created the file again, used the password to...

Newbie at best on anything really deep in the Excel world. Basic skills, watched a few YouTube videos. A separate application requires the use of XML mapping to function. This is something that cannot be changed. I have created a XML workbook that makes use of VLOOKUP and some calculation...

How can I protect my macros from editing or even viewing?

Hello I need a VBA code to protect all cells containing formulas only and let me input data in cells not containing formula. the file has multiple sheets. Of course I need a password and do I need to run this code every time I open the file or just run it once, and what if I delete the code...

Hi all, I'm trying to set up protection on my excel sheet.. and the way I imagine it, would be, when someone opens the workbook, they have to input a password, if they don't or the password isn't correct, they can only observe the workbook, and can't even select cells or do anything. Then if...

Hi, i am trying to unprotect my worksheet to run below code for converting columns into text and then protect sheet again but somehow its not working. Please help! Sub EWEB2() Dim ws As Worksheet Set ws = Worksheets("EWEB") ws.Select ws.Unprotect Password:="dim" Columns("G:G").Select...

Hi: I have a sheet with drop-down box which drives other calculations on that sheet. When I protect the sheet and then select from the box, the formulae don't update and get message 'The cell or chart you are trying to update is on a protected sheet..........". How can I protect a sheet but...