| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing and Applying protection in VBA
Neil,
Change ActiveWorksheet to ActiveSheet -- sb "Neil Warwick" wrote in message ... Is there a way that I can remove and add protection to the worksheet in VBA on Excel 2000 / XP? According to the online help I can use the commands:- ActiveWorksheet.Protect and ActiveWorksheet.Unprotect I have tried to use them in the format shown below, but they don't seem to work correctly. ActiveWorksheet.Unprotect "frodo" ActiveWorksheet.Protect Password:="frodo" I'm pretty new to all this VBA stuff so any help would be appreciated (Can anyone recommend a good book?) Thanks Neil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing password protection | Excel Discussion (Misc queries) | |||
| Applying Protection To Multiple Sheets | New Users to Excel | |||
| Removing Module Protection Programatically | Excel Discussion (Misc queries) | |||
| Removing protection from excel worksheets | Excel Worksheet Functions | |||
| Applying protection to an Excel Expense Report | Excel Programming | |||
Threaded Mode
