Forum Discussion

Copper Contributor

Oct 14, 2020

Protecting an Excel workbook

I am using Excel 97-2003 and thus far have been able to protect (Encrypt with password) a workbook with a password, but this option only gives me access to the document. I need to protect the docume...

Copper Contributor

Oct 14, 2020

mtarler Going through the save as box is what I needed to protect the document, but yet allow others to read it.

Thank you very much!

Platinum Contributor

Oct 14, 2020

As Mr. mtarler already informed you, you can do this with the command "Protect workbook". But with Excel you have several possibilities to accomplish something, depending on your needs and knowledge. One of these possibilities is also VBA. Here is additional information about what Mr. mtarler has already described and with VBA macro as an example.

Protect a worksheet

https://support.microsoft.com/en-us/office/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6?ui=en-us&rs=en-us&ad=us

Protect a workbook

https://support.microsoft.com/en-us/office/protect-a-workbook-7e365a4d-3e89-4616-84ca-1931257c1517?ui=en-us&rs=en-us&ad=us

Sub protection ()

ActiveSheet.Protect Password: = "Password Name", UserInterfaceOnly: = True, DrawingObjects: = True, Contents: = True, Scenarios: = True

End Sub

Sub unprotection ()

ActiveSheet.Unprotect Password: = "Password Name"

End Sub

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

Resources