Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
password problem with protect worksheet
i tried to protect worksheet with password, then unprotect again, but it
doesn't work, it shows password error. i simply used like activeworksheet.protect password := "abc" then activesheet.unprotect password:="abc" anybody can advice where i m wrong? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
password problem with protect worksheet
This is a copy of coding that is running in an apps of
mine. Remember to protect each sheet by running a VBA prog Sub MyProtect() ActiveWorkbook.Protect Password:="ZAC" ActiveSheet.Protect Password:="ZAC" End Sub Sub MyUnprotect() ActiveWorkbook.Unprotect Password:="ZAC" ActiveSheet.Unprotect Password:="ZAC" End Sub -----Original Message----- i tried to protect worksheet with password, then unprotect again, but it doesn't work, it shows password error. i simply used like activeworksheet.protect password := "abc" then activesheet.unprotect password:="abc" anybody can advice where i m wrong? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
password problem with protect worksheet
Try ActiveSheet.Protect "abc"
and ActiveSheet.UnProtect "abc" -----Original Message----- i tried to protect worksheet with password, then unprotect again, but it doesn't work, it shows password error. i simply used like activeworksheet.protect password := "abc" then activesheet.unprotect password:="abc" anybody can advice where i m wrong? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
password problem with protect worksheet
ur suggestion works
thanx "Steve B" wrote in message ... Try ActiveSheet.Protect "abc" and ActiveSheet.UnProtect "abc" -----Original Message----- i tried to protect worksheet with password, then unprotect again, but it doesn't work, it shows password error. i simply used like activeworksheet.protect password := "abc" then activesheet.unprotect password:="abc" anybody can advice where i m wrong? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way that I can password protect a worksheet | Excel Worksheet Functions | |||
Password Protect a Worksheet | Excel Discussion (Misc queries) | |||
password protect cells problem | Excel Discussion (Misc queries) | |||
Protect a worksheet with a password | Excel Worksheet Functions | |||
password protect worksheet | Excel Discussion (Misc queries) |