password protect macro
How do I run a macro that will unprotect the sheet by entering the password,
run the macro, and then password protect the sheet again by re-entering the password after the macro runs so users are not able to tamper with the data in the spreadsheet? I get an error when I try this with an actual password, but it works if I protect the sheet without a password. Thanks for your help. |
password protect macro
should work fine - see
ActiveSheet.Protect Password = "FRED" ActiveSheet.Unprotect Password = "FRED" which (rather pointlessly) protects and unprotects a sheet without doing anything else |
password protect macro
Thanks Aidan. It works, but for some reason when I try to unprotect the
worksheet from Excel and put in the password it's telling me that my password is incorrect. When I run the macro which protects and unprotects the worksheet with the password it works fine. Any thoughts? "AidanH" wrote: should work fine - see ActiveSheet.Protect Password = "FRED" ActiveSheet.Unprotect Password = "FRED" which (rather pointlessly) protects and unprotects a sheet without doing anything else |
password protect macro
(AidanH replying from home!) - I would GUESS that the sheet is already
protected with a password different from the one you expect (perhaps CAPS instead of caps - these are different to Excel you see) "Modell" wrote in message ... Thanks Aidan. It works, but for some reason when I try to unprotect the worksheet from Excel and put in the password it's telling me that my password is incorrect. When I run the macro which protects and unprotects the worksheet with the password it works fine. Any thoughts? "AidanH" wrote: should work fine - see ActiveSheet.Protect Password = "FRED" ActiveSheet.Unprotect Password = "FRED" which (rather pointlessly) protects and unprotects a sheet without doing anything else |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com