Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've developed a workbook with a number of sheets. I want to prevent users
from copying or deleting sheets without suitable control so I used Excel VBA code to protect and unprotect the workbook. The problem is that when I protect the workbook with a password, when I get back to Excel I am able to unprotect the workbook without providing the password. Can anyone explain what I'm doing wrong please? The code is: dim wkbkone as workbook Set wkbkone = Application.ActiveWorkbook wkbkone.Protect "abcd" wkbkone.Protect "abcd" ActiveWorkbook.Protect Structu=True, Windows:=True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to remove password protect to open Excel 2007 workbook | Excel Discussion (Misc queries) | |||
How do I password protect an excel workbook? | Excel Discussion (Misc queries) | |||
How do I password protect a workbook in Excel? | Excel Discussion (Misc queries) | |||
How to password protect several excel workbook pages using a macro | Excel Programming | |||
password protect on workbook problem | Excel Programming |