protected

Hi, It is possible to write a macro, for closing password protected excel file, on wrong password entry and no-entry for 10 seconds. regards Metin

First, I am not trying to crack any passwords. I am, instead, trying to make sure that a large folder of excels all have been password protected. Obviously, the issue with something like the below is that I have to open the password protected wb to set the variable (which I can't do with a...

I just got done creating a couple of password protected files (.xlsm). Works fine when using Excel, but I can open them with LibreCalc and all the worksheets can be unlocked/unhidden without any password protection. Any solutions for this?

I have something weird going on with a spreadsheet that I'm working in and given to me by a co-worker to complete. If I open the spreadsheet, it is not password protected. I am able to change column widths, font color, etc UNTIL I enter data in any cell. Once data is entered in a cell, the...

I just put in VBA for 'ThisWorkbook: Private Sub Workbook_Open() OpenWHSE.Show Sheet2.Protect Password:=True, UserinterfaceOnly:=False End Sub After running it, it protected the stuff I want. I want to do some more editing and go to unprotect, and says I didn't put in the correct...

This for us learners (newbies to VBA) I learned that if I include the below after writing my code and before 'End Sub', my worksheet will go into protected mode after the code is ran. ................................................... ActiveSheet.Protect Contents:=True End Sub...

Hi folks, is there any way to insert a table into an unlocked Excel cell (or merged range of cells) on a protected worksheet? I've tried convering to an image but it doesn't retain the formatting.

Hello I have added sheet protection. There are only three columns of info in the sheet, and all of them are locked under Format Cells/Protection/Locked. When I protected the sheet, it gave me options to allow certain functions while protected. I chose: Select Locked Cells Select unlocked...

Hi All, Since receiving a new laptop from work, a macro that I run has consequently started saving files in "protected view" (with the red bar along the top to say everything is disabled). This means that I am subsequently having to open each of the files that are created in order to select...

code Sub test8() ' ' test8 Macro ' ActiveWindow.ActivateNext Application.ActiveProtectedViewWindow.Edit ActiveWindow.ActivateNext End Sub Hi Experts, I have a protected view file and a normal one. I am trying to run the above code from the normal one but I'm getting run time error...

Hello, How do I create a protected worksheet with formulas so I can share with other people but make sure they can not change my formulas I have created. How would I go back and chance my formulas too if I needed. Thanks! Morgan

I am very much self taught when it comes to most things in Excel so I am not even sure if what I am trying to do is possible. I have a worksheet that is being used to track information from the production runs. I have the sheet locked and protected except for the cells I want them to be able to...

I use the code to automatically sort the table by attribute "Name" from column B. Private Sub Worksheet_Change(ByVal Target As Excel.Range) On Error Resume Next If Not Intersect(Target, Range("A:Z")) Is Nothing Then Range("B5").Sort Key1:=Range("B6"), _ Order1:=xlAscending...

Hi, I am using below code for consolidate multiple workbook, however I want to consolidate data from Sheet1 which is protected. so is it possible to consolidate data from Protected sheet. Option ExplicitDim fsoMain As New FileSystemObjectDim myFldr As FolderDim myWB As Workbook, tempWB As...

I am trying to find out if there is a way to automatically unlock a protected cell based on the contents of the cell. I have a spreadsheet that is password protected. I am looking for a way to unlock a particular cell if the result of the formula in the cell is an error or a certain result...

First time doing this... I've created a script at this point that is doing what I want. I've also applied this bit below to the Sheet tab in order to cause the cells to be updated automatically any time certain cells are modified: Private Sub Worksheet_Change(ByVal Target As Range) If Not...

I've seen a couple of things close to this but this is a little odd. I have a password protected file "Mater File Links" Its protected from the general public (of this office) The way the data is entered is through another Workbook. Before I was forced to protect the "Master File Links" the...

Hi, How to open a password protected workbook through power query? Thanks in advance for a help.

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...

Hi all, I have this code that copies data from A1 down to J1 and down where the cells in column C (3) is not empty. Sub FilterData() ActiveSheet.AutoFilterMode = False Range("J1:Q" & Range("J" & Rows.Count).End(xlUp).Row).ClearContents Range("A1").AutoFilter Field:=2, Criteria1:="<>"...