1. First, create a simple macro that you want to protect. Range("A1").Value = "This is secret code" 2. Next, click Tools, VBAProject Properties. 3. On the Protection tab, check "Lock project for viewing" and enter a password twice. 4. Click OK. 5. Save, close and reopen the ...
I tried to make a macro, by recording a macro, that was supposed to Protect a workbook with an encrypted password when a certain condition was met. The problem is, that it seems not to be able to re... mtarlerThank you. This runs neatly. But what I needed is not protection ...
Could your macro be changed to have the function be: File-Info-Protect Workbook-Encrypt with Password? egillhelgaso this appears to be the same as the Save As option except with the Save As option you can select a PW for open (encryption) and a different PW for edit. ...
Hello All, I have placed an ActiveX controls button in a worksheet that will perform a macro. I want to lock the worksheet so that users can only access the cells I designate and also run this macro to validate their data input. My issue: When I run the macro with worksheet locked, ...
Excel Macro to UnProtect your Protected Sheet To Unprotect your already protected sheet, you need to useWorkSheet.unprotectmethod. To Unprotect a Sheet all you need to pass is the password. No other parameter required to unprotect a sheet. Password is NOT required in all case. You need to pa...
Save your file. VBA Coding Made Easy Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users! Learn More!VBA...
7. Save the workbook as Excel Macro-Enabled Workbook format and close it to make the password protection take effect.8. Next time, when you open this workbook, and want to make the veryhidden sheets be visible, you are requested to enter a password. See screenshot:Demo...
Sub Protect_Hidden_Columns() Dim HPassword As String Range("B5:H13").Select Selection.Locked = True HPassword = InputBox("Type Password to Protect Hidden Columns") ActiveSheet.Protect Password:=HPassword End Sub Close the Visual Basic window. Press Alt+F8. In the Macro dialog box opens, ...
(1) Go into the VBE (Tools > Macro > Visual Basic Editor). (2) In the Project Explorer window (typically the left vertical pane in the VBE), select by highlighting the VBA Project you want to protect. This will be your workbook, in bold type, with the syntax VBAProject (YourFileNam...
Hi, I need to password protect hundreds of exel files with the same password, but my boss wants them done one by one (as opposed to a zip file). The files are in different directories and have different names. Can I create a macro that will do the