protection

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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