| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet
i want to open a protected sheet - where protection has been done usin
a passowrd. and then later protect the sheet again using a password -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet
Hi
use something like activesheet.unprotect password:="yourpassword" 'some code activesheet.protect password:="yourpassword" -- Regards Frank Kabel Frankfurt, Germany i want to open a protected sheet - where protection has been done using a passowrd. and then later protect the sheet again using a password. --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
| Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
| when you protect a sheet, you can't enter using a form | Excel Discussion (Misc queries) | |||
| Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel | |||
| protect sheet macro - can't have it enter password | Excel Programming | |||
![arunjoshi[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
