1. B

    Having cell show if worksheet is protected or unprotected

    As im sure you can tell in the code below that when I select cell E1 in sheet 2 it calls to run a macro to toggle protect and unprotect of sheet 2. I was wandering if there could be something added to the LockUnlock() code so cell E1 would actually show the text "PROTECTED" OR UNPROTECTED"...
  2. F

    Excel Workbook Licensing/Security System

    Hey Team, Was wondering if anyone has had to use / build a security system for a workbook before? At our company we have a workbook that we make copies of for each project but we only want specific people to have access to it. We also do not want them to be able to take it outside of the...
  3. H

    Help with VAB unprotecting sheets

    Hello My code is set to wipe a workbook based on a date Private Sub Workbook_Open() Dim ws As Worksheet ' Check to see if specified date is passed If Date >= DateSerial(2023, 7, 6) Then ' If it is, loop through all sheets For Each ws In ActiveWorkbook.Worksheets '...
  4. F

    Lock Down Spreadsheet to Specific Users

    Hey Team, Curious questions here. My company has just finished developing an Excel Spreadsheet full of VBA code and functions that we wanted to protect. Is there a way that we can lock down our spreadsheet from an access perspective. Like you have to have some credentials to be able to sign...
  5. Engineer Joe

    Lock access to the VBA project via VBA

    Either my google-foo skillz are waning or google itself just isn't useful in finding the distinction in my inquiry, so here I am. Long time, no see Mr. Excel. Let me preface my question with this. When you go into in the VBA project for an Excel file and click on the Tools Dropdown and select...
  6. S

    Importing operating system information into excel.

    Hi all, I am currently wondering how to allow only a single user to use my excel spreadsheet. That is I send it to the person, they download it, and then if they try to send it to someone else, the formulas in the spreadsheet stop functionning. My inital thought was to make a formula ,using...
  7. G

    Excel protection: allow specified people to use/modify macro, but prevent them to change protection

    This question is a bit complicated. My ultimate goal is to prevent other companies from using our macro-excel, but employees in my company can see/modify the macro. This includes preventing employees in my company to remove/change the protection system. So far I can allow specified people to...
  8. Y

    Merge/Unmerge Cells in a Protected Sheet

    Hello everyone, I have an excel sheet where I have some cells protected, unfortunately I can't merge/unmerge cells while the sheet is protected. So, I have written this VBA code Sub MergeCells() Application.ScreenUpdating = False ActiveSheet.Unprotect "Password" Selection.Merge...
  9. L

    Workbook protection activates after every change

    I realize this is a dumb question. I originally costumized this workbook so that people at my old job could use it without editing any of the structure behind it. Now I'm back to working on it, but everytime I launch a macro and the like, the workbook protection gets turned back on after I'd...
  10. Z

    Do I need any macro to set sheet veryhidden?

    Hi, I want to set one of my sheet to be non visible. I have set its properities to xlsheetveryhidden, but project protection by password does not work. It will be enough when I add any (even blank) sub inside?
  11. B

    Form Control Checkbox - Multiple Checkboxes

    Hello, I have a document that has a couple of sheets. Sheet 1 has 3 rate plans 1. Basic 2. Standard 3. Platinum Each rate plan has the inclusions documented on another sheet in the same workbook. What I would like to know is it possible for a rate plan to be selected and the inclusions on...
  12. H

    Macro to copy worksheet to new book, then turn on protection

    I have a spreadsheet that I want to send outside of my organization, so that people can fill it in them return the spreadsheet to me. I'll set up protection to prevent unwanted modifications to the SS. It would look something like this.... 1. I edit a worksheet and get it ready to go out to...
  13. V

    VBA script help needed to unlock a sheet to add a new line then protect again

    Hello there, I have a 47 (AA - AU) column table which has 8 Formulae which i need to protect from overwriting, however the table needs to have the ability to add new rows on a daily basis, I have used data validation to protect the cells, but much to my amusement you can still copy and paste...
  14. C

    Protection - One time usage only in Office 365

    When I protect/unprotect cells and then protect the worksheet I allow users to Sort / AutoFilter / Insert Rows. They are only able to perform these functions once and then that ability is removed and they can no longer perform those functions. Is there a way to override this and always allow...
  15. merlin_the_magician

    protection vs validation

    I make quite a few spreadsheets, intended to be filled out by others. To make them user-friendly (or idiot- proof, as you like…), I like to use data validation for input information, error messages and data limitations. Upon selecting a cell, users are presented with information the content...
  16. L

    TAB Order in Excel

    Hi, I have found various VB code to set the tab order in excel but this only works with sheet protection turned on. I am after something that will work with sheet protection turned off. The reason is I have some code for an activex combo box that doesn't respond, as it should, with the...
  17. M

    put Data.xlsx to website/cloud

    I want to put my data.xlsx to my website Now my PowerBI can get the data by web. However it does not have security. What is the protection I can implement ? It is not sensitive data but still I want some kind of elementary protection What can we do ? By the way, any chance for PowerBI to get...
  18. S

    Macro Protection

    Hi, I work on Excel 2013. For unknown reason, I can't password protect the vba project. I follow this steps - ALT F11 TOOLS --> VBAProject properties Protection click on "lock project for viewing" enter & confirm password save & exit visual basic save file as *.xlsm exit but after I open the...
  19. L

    VBA sheet protection

    Hi All, thanks in advance for looking, This might have been answered before but if it has I haven't found it. I think i might be asking the impossible but here goes. I would like to try and protect my workbook as much as possible from the zip extension hack. I have a workbook with around a...
  20. M

    Excel online sheet protection

    Hi Guys, I hope you guys can help me out with this problem. I want to share a file on Sharepoint with 9 different users that use Excel Online (So macro's wont work). Each user has his own sheet, but they must not be able to edit each-other's sheet. They are not able to re-apply sheet...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back