| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"How do I un/protect sheet by macro program with password
I need to input data only by macro programming.
Data sheet must be protected and only macro can unprotect to write data entry. Then macro protects data sheet again to avoid any change. I already try to protect with menu: Tools Protection Protect sheet But macro cannot remember the password. Password is now always blank, which means can be unprotected by anybody. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to re-protect sheet w/ original password after pasting valuesin new book | Excel Worksheet Functions | |||
| Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
| How to crack "Protect Sheet" Password in Excel? | Excel Programming | |||
| no password carryover with "protect sheet" in macro | Excel Programming | |||
| protect sheet macro - can't have it enter password | Excel Programming | |||
Threaded Mode
