| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password a Macro so certain users can press it
I have a cell on my worksheet which is protected via the usual password
protect worsheet thing. However, i want to allow one person to write in this cell my pressing a macro which allows him to do this, then lock again after if possible? Anyone any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Password a Macro so certain users can press it
you could use an inputbox to ask for a password
-- Don Guillett SalesAid Software wrote in message oups.com... I have a cell on my worksheet which is protected via the usual password protect worsheet thing. However, i want to allow one person to write in this cell my pressing a macro which allows him to do this, then lock again after if possible? Anyone any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Password a Macro so certain users can press it
This may help......
Sub EnterValueInProtectedCell() Range("A1").Select ActiveSheet.Unprotect Password:=("aaa") Dim k k = InputBox("Enter new value for cell A1:") Range("a1").Value = k ActiveSheet.Protect Password:=("aaa"), DrawingObjects:=True, Contents:=True, Scenarios:=True Range("A1").Select End Sub Vaya con Dios, Chuck, CABGx3 " wrote: I have a cell on my worksheet which is protected via the usual password protect worsheet thing. However, i want to allow one person to write in this cell my pressing a macro which allows him to do this, then lock again after if possible? Anyone any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| develop a macro which takes password protection on and off | Excel Discussion (Misc queries) | |||
| Password restricted single macro and button | Excel Discussion (Misc queries) | |||
| Add protect worksheet password in macro | Excel Worksheet Functions | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| don't allow users to assign the cntrl+s as a short cut for macro | Excel Worksheet Functions | |||
Linear Mode
