| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect/Unprotect w/ VBA not working as supposed...
Hello,
My protecting Excel 97 VBA-code is as follows With ActiveWorkbook.Sheets("MAIN") .EnableSelection = xlUnlockedCells .EnableAutoFilter = True .Protect Contents:=True, userInterfaceOnly:=True One of the Unprotect codes is Sheets("Main").Select ActiveSheet.Unprotect ....but ....after unprotect, copy/paste is not possible. What can be wrong with the protect code? How can I restore the complete unprotect state? HBj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect, unprotect | Excel Discussion (Misc queries) | |||
| Is there any way that you can protect or unprotect a group of wor. | Excel Discussion (Misc queries) | |||
| Unprotect and protect.... | Excel Programming | |||
| protect / unprotect worksheets using VBA | Excel Programming | |||
| Protect\Unprotect VBA project | Excel Programming | |||
Threaded Mode
