Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on worksheet protection and breaking macros
Hello,
I actually posted these questions in another forum, but I thought i might help to post them here, too. I am trying to do two things I nee assistance with: 1). I am trying to incorporate a password in my macro using workshee protection. I am familiar with the code: ActiveSheet.Protect but I don't know how to incorporate the password into my code t protect and unprotect (as with Workbooks.Open and password:= ****, fo instance). Does anyone know if this is possible to do? and 2). Does anyone know if there is a way to automatically close workbook (unsaved) that a macro is acting on should the user try t break the macro in runtime (as in Ctrl+Break)? Any advice would be much appreciated. Thanks, -Pet -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Protection Question | Excel Discussion (Misc queries) | |||
Worksheet protection question | Excel Discussion (Misc queries) | |||
Cell/worksheet protection with macros enabled | Excel Worksheet Functions | |||
A Worksheet Protection Question | New Users to Excel | |||
Excel97 - Worksheet Protection Question | Excel Programming |