excelsecurityxla
How to protect Excel xla from editing with password
I want to give users the ability to use the xla module without specifying the password but whenever someone tries to edit or view the VB source code of the module it should ask for a password.
Is this possible to do in Excel? If so how can this be achieved?
Solution
Yes this is possible.
1- Open VBa editor and right click on the project
2- In properties dialog, you can lock the code with a password
Take a look at below
- Excel LET Formula Results in #CALC! Error When Applying a Filter
- Save excel file using savefiledialog class in C#
- Excel, generate a list of names depending on row and column values of another sheet
- Ignore missing columns in pandas read_excel usecols
- When does Excel surround sheet names with single quotes in workbook.xml (or other xml) files?
- getting sheet names from openpyxl
- Counting number of unique values in one column if data in a 2nd column matches anything in a 3rd column
- How to add more than 255 characters in a data validation in xlsxwriter Python
- Open Excel File on a specific worksheet
- Including a value in a range to be summed, only if a date is not today
- XLOOKUP with flexible column for return_array and not unique values in lookup_array
- Get Picture from Worksheet into Excel Userform
- Get names from email column
- How to add the data in the same row index but in different cells in each column
- Consolidating all sheets data into another work book
- Repeat each value a different number of times. Excel
- How to convert a column of age counts into a set useful for statistics?
- VBA Excel Break Points and Stop do not work
- How to find average per day using pivot table?
- Using Excel for VLOOKUP and WildCard Not Working
- Resort from descending to ascending
- Create a scatter in excel using vbscript
- Add cell with comment above table header and matching cell values VBA
- Can you define names for dates in Excel to use them in formulas?
- Override spill cell
- How to create an Excel File with javascript?
- Formula for generating delimited list of incremented numbers
- Return offset cell value based on data validated dropdown list
- Why I could not simply read sheets and merge all the content in a single Variant?
- Extract comments from multiple word docs into Excel