Macro Button to Save as Read Only + Password

**Hirani** · 09-19-2010, 11:10 AM

Hello All,

I was wondering if it's possible to design an excel template where there is a button.

And when I click the button, the file is saved as read only with a secret password that only I know. Prefable with date time noted somewhere in the file or as the file name.

Basically I want to create templates that my staff can enter data but be able to edit after saving.

Is such a thing possible?

**royUK** · 09-19-2010, 11:45 AM

Try this code, amend it to suit' MyWorkbook is the file name, secret is the password

Please Login or Register  to view this content.

**Hirani** · 09-19-2010, 12:10 PM

Originally Posted by royUK

Try this code, amend it to suit' MyWorkbook is the file name, secret is the password

Please Login or Register  to view this content.

Wow thanks for the prompt reply. Would it also be possible to have the date & time in the file name?
Perhaps also to have the date and time in the sheet also?

Umm...I forgot to mention that Im new at excel.
I just know how to record a macro and assign it to a button.

Where to I put this code and assign it to a button?
Sorry for not mentioning earlier that im new

**royUK** · 09-19-2010, 12:35 PM

The date is already in the file name, to add the time use this

Please Login or Register  to view this content.

See Add a button

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

**Hirani** · 09-19-2010, 12:47 PM

Ok I figured it out how to assign it to a button. The file get saved and when I try to open it, excel asks me for a password. I enter the password to open the file but then excel asks me or another password for read and write access. When I enter the same password, excel says it's incorrect. So now I'm only able to open as read only. What am I doing wrong here if I want to edit?