| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlocking and Locking in a Marco
I have a marco that will only work if the sheet is unprotected. Can I make my
marco unlock the sheet in the beginning and then lock it when completed. Hope you can help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unlocking and Locking in a Marco
try this
worksheets("Sheet1").unprotect "password" 'run your code here worksheets("Sheet1").protect "password" "JBoyer" wrote: I have a marco that will only work if the sheet is unprotected. Can I make my marco unlock the sheet in the beginning and then lock it when completed. Hope you can help! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unlocking and Locking in a Marco
That's all I needed. THANKS!
"Mike" wrote: try this worksheets("Sheet1").unprotect "password" 'run your code here worksheets("Sheet1").protect "password" "JBoyer" wrote: I have a marco that will only work if the sheet is unprotected. Can I make my marco unlock the sheet in the beginning and then lock it when completed. Hope you can help! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unlocking and Locking in a Marco
Your welcome
"JBoyer" wrote: That's all I needed. THANKS! "Mike" wrote: try this worksheets("Sheet1").unprotect "password" 'run your code here worksheets("Sheet1").protect "password" "JBoyer" wrote: I have a marco that will only work if the sheet is unprotected. Can I make my marco unlock the sheet in the beginning and then lock it when completed. Hope you can help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locking and unlocking worksheets | Excel Worksheet Functions | |||
| Locking/Unlocking cells upon condition | Excel Discussion (Misc queries) | |||
| Locking/Unlocking sheets using a range. | Excel Programming | |||
| Locking and unlocking a workbook | Excel Programming | |||
| Locking/unlocking cells | Excel Programming | |||
Linear Mode
