protect worksheet

Hi I have a SharePoint list exported to an Excel table which I'd like to keep as a live connection by using Data > Refresh All. I'd like to lock the table so it cannot be sorted, but that it can still be filtered. I tried this through Sheet Protection (only blocking sorting but allowing...

Hi Is there a way to protect and hide cells with formula using VBA while editing other cells? Currently I am using this code which does not allow me to editing some of the cells. Sub HideFormula() Selection.Locked = True Selection.FormulaHidden = True ActiveSheet.Protect Password:="1234"...

Thanks for this awesome forum! I have Excel 2016 on a Windows 10 machine to which I do not have Admin access. I'm very comfortable with Excel, but haven't used VBA or macros very much, at all... so please talk slowly if you suggest those methods as a possible solution. ;-) I have a lot of...

I am fairly new to Excel. I need to create cells where anyone can enter data into a blank cell but not be able to delete the data once entered. Ideally the only function I would like is to allow the user to be able to perform a strike through once data is entered.

I am a newby when it comes to working with VBA a Macros so please excuse my ignorance. I appreciate the help I have found on this forum. 64-bit operating system with Excel 2016 32-bit I have a workbook with 3 worksheets. Sheet one (Action Plan) contains a table with filters turned on that will...

hi. I was just wondering, with lots of add-ins available nowadays to break passwords for excel worksheets, is there any way we could protect our passwords from being hacked. let's say a vba which could protect a worksheet from add-ins like Ultimate Add-in. Thanks in advance =D

I don't know if this is possible, but is there a way to get Excel to trigger a macro whenever a user either protects or unprotects a certain worksheet within a workbook via Protect/Unprotect Sheet. Ideally, I would like to be able to trigger one macro if the worksheet is protected and a...

I want to make a worksheet in my excel to have only read only access (user shouldn't be able to make changes to that sheet). I tried protecting the worksheet but making so will give an error in my code. My code basically makes some changes into that worksheet. Is there a way out to make the...

What is an easy method to protect a worksheet in a shared workbook. The workbook needs to be shared so multilple people can update their weekly numbers (several columns, cells need to be updated weekly by multiple people) The worksheet needs to be protected somehow because people are somehow...