| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA-Protect and unprotect sheet with BVA
I can`t run a macro because the cells are blocked and the shee
protected. How do I unprotect and protect a sheet with BVA code tha include a prestablished pasword. Thanks in advance -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VBA-Protect and unprotect sheet with BVA
Sheets("Sheet1").UnProtect("YourPwd")
Sheets("Sheet1").Protect("YourPwd") HTH Regards Pascal "marfrk " a écrit dans le message de news: ... I can`t run a macro because the cells are blocked and the sheet protected. How do I unprotect and protect a sheet with BVA code that include a prestablished pasword. Thanks in advance. --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
| Protect - Unprotect Sheet - Visual Source Safe | Excel Discussion (Misc queries) | |||
| unprotect/protect grouped worksheets in excel | Setting up and Configuration of Excel | |||
| Protect/unprotect sheet with password with VBA? | Excel Programming | |||
| VBA code - protect and unprotect a sheet | Excel Programming | |||
Linear Mode
