Code to protect sheet
what will be the VB code to protect sheet. thnaks
|
Code to protect sheet
With a password or not?
These apply a password. Sub SHEETPROTECT() ActiveSheet.Protect Password:="justme" End Sub Sub SHEETUNPROTECT() ActiveSheet.Unprotect Password:="justme" End Sub Note: if youe users are snoopy, you should lock your VBA Project for viewing. And be aware that worksheet and workbook protection is easily cracked so protecting a sheet only prevents accidents. Gord Dibben Excel MVP On Wed, 21 Dec 2005 12:42:02 -0800, "Conditional Formatting" wrote: what will be the VB code to protect sheet. thnaks |
All times are GMT +1. The time now is 09:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com