Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to protect a sheet after the information update.
I have a form with 3 tabs on it. There are specific fields that they are
allowed to enter in their time. It is protected right now with a password and my PMP team will use it to document time for their projects. After the initial assessment of a project, my team runs a macro that takes the protection off then deletes the range of cells that they were allowed to enter their time and protects the entire worksheet. I have created a macro to lock the entire sheet but I have been unable to protect the sheet using a password inside of a macro. As the file stand now the customer can click on tools/protection/unprotect and change any field they want. I created the macro because my team members are not that excel savy. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to protect a sheet after the information update.
Activesheet.Protect Password:="ABC"
protects the sheet with a password for me. Activesheet.Unprotect Password:="ABC" unprotects it after the password is applied. -- Regards, Tom Ogilvy "Patrick Antus" wrote: I have a form with 3 tabs on it. There are specific fields that they are allowed to enter in their time. It is protected right now with a password and my PMP team will use it to document time for their projects. After the initial assessment of a project, my team runs a macro that takes the protection off then deletes the range of cells that they were allowed to enter their time and protects the entire worksheet. I have created a macro to lock the entire sheet but I have been unable to protect the sheet using a password inside of a macro. As the file stand now the customer can click on tools/protection/unprotect and change any field they want. I created the macro because my team members are not that excel savy. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to protect a sheet after the information update.
Thank you Tom. I needed that "=". Excel help did not come close to helping
but you did. "Tom Ogilvy" wrote: Activesheet.Protect Password:="ABC" protects the sheet with a password for me. Activesheet.Unprotect Password:="ABC" unprotects it after the password is applied. -- Regards, Tom Ogilvy "Patrick Antus" wrote: I have a form with 3 tabs on it. There are specific fields that they are allowed to enter in their time. It is protected right now with a password and my PMP team will use it to document time for their projects. After the initial assessment of a project, my team runs a macro that takes the protection off then deletes the range of cells that they were allowed to enter their time and protects the entire worksheet. I have created a macro to lock the entire sheet but I have been unable to protect the sheet using a password inside of a macro. As the file stand now the customer can click on tools/protection/unprotect and change any field they want. I created the macro because my team members are not that excel savy. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update information if date changes | New Users to Excel | |||
Macro with protect sheet | Excel Discussion (Misc queries) | |||
Protected Sheet doesn't update linked information | Excel Discussion (Misc queries) | |||
How to create a Macro to Copy Information in one sheet to another sheet. | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming |