| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Request password during Protect macro
Got it! The Dialog boxes toggle protection on and off. If I don't sen any agruments then if protection was on, excel asks for a password an thurns protection off. If protection was off, then excel asks for password, asks for confirmation of the password, and then turn protection on. Fantastic : ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to allow auto filter after running password protect | Excel Discussion (Misc queries) | |||
| Macro to re-protect sheet w/ original password after pasting valuesin new book | Excel Worksheet Functions | |||
| Password Protect Macro - Compile Error | Excel Discussion (Misc queries) | |||
| Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
| Add protect worksheet password in macro | Excel Worksheet Functions | |||
![Gavin[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
