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

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

I wrote the code below for a lock and unlock process. First one (Lock) is supposed to state if the worksheet (Change Record) is already locked then show that it's already protected with a timed message box....else (if false) then lock the worksheet. The second (Unlock) is doing the opposite. If...

Hi, I have found the following code on the Internet which has allowed me to protect all the formulae in a Workbook, however, I need to be able to unhide any column or row to view without removing the password protection. Could someone, please help me modify the code below to allow this for me...

Hello, I'm trying to use a toggle button to protect and unprotect a worksheet. I have this code Private Sub ToggleButton1_Click() If ActiveSheet.ProtectContents = True Then ActiveSheet.Unprotect "test" Else ActiveSheet.Protect "test" End If End Sub Although, It works (in a sense that...

I'm working with a table so that formulae copy with each new entry. But when I protect the sheet, the table quits working. Is there a solution for this?

Hi, I have a report to prepare where I am giving a command button. The code behind the command button inserts a sheet, edits that and deletes it finally (It is meant for printing something). However, I want to protect the report and do not allow user to edit anything. One way I thought was...