| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect a sheet with pasword
Hi, I want to make a macro, ehn the user press a button, the sheet is
automatically protected with the pasword:= "galileo" TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to protect a sheet with pasword
Try something like
Sub ProtectSheet() ActiveSheet.Protect password:="galileo" End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "filo666" wrote in message ... Hi, I want to make a macro, ehn the user press a button, the sheet is automatically protected with the pasword:= "galileo" TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to protect a sheet with pasword
tanks chip, it works¡¡¡¡¡¡
"Chip Pearson" wrote: Try something like Sub ProtectSheet() ActiveSheet.Protect password:="galileo" End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "filo666" wrote in message ... Hi, I want to make a macro, ehn the user press a button, the sheet is automatically protected with the pasword:= "galileo" TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hellllllp Can,t remember pasword | Excel Worksheet Functions | |||
| Excell VBA pasword | Excel Discussion (Misc queries) | |||
| Protect Workbook Vs Protect Sheet | New Users to Excel | |||
| Login to a web page & automatically fill in pasword | Excel Programming | |||
| Lock and protect cells without protect the sheet | Excel Programming | |||
Linear Mode
