| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to unlock and lock cells in password protected sheet
Hi all
Is there any way I can get a macro to unlock cell, paste valuse and the lock again after completion. I have a macro to transfer valuse from one rang to another. The macro will work ok if I leave the input cells unlocked. I would like to be able to lock these cells so they can't be changed without the the use of the macro. The input cells are F23:F23. See Code Below. Regards Chris Sub update() Worksheets(13).Range("I20:I23").Copy Worksheets(13).Range("F20:23").PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I unlock the excell password protected file? | Excel Discussion (Misc queries) | |||
| I FORGOT MY PASSWORD AND THE EXCEL SHEET IS LOCK HOW CAN I UNLOCK | Excel Discussion (Misc queries) | |||
| finding the password to unlock a protected cell/chart | Charts and Charting in Excel | |||
| how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
| How do I unlock a spreadsheet that is password protected? | Excel Worksheet Functions | |||
Threaded Mode
