| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lock a cell from users but not macros
I have a work sheet my macro copys data into. When i just protect the sheet
the macro will not run. Is there a way to lock it so the macro will still work but the users can not edit the data. Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
lock a cell from users but not macros
Hi
Unprotect the sheet at the top of the macro and then re-protect at the end. Regards, Per "Miree" skrev i meddelelsen ... I have a work sheet my macro copys data into. When i just protect the sheet the macro will not run. Is there a way to lock it so the macro will still work but the users can not edit the data. Thank you |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
lock a cell from users but not macros
Is there a way to get this to work with a password? when i tried to do it
with password it needed a user input, to unprotect, i dont want my users to have the password. Also it doesn't lock with a pass word "Per Jessen" wrote: Hi Unprotect the sheet at the top of the macro and then re-protect at the end. Regards, Per "Miree" skrev i meddelelsen ... I have a work sheet my macro copys data into. When i just protect the sheet the macro will not run. Is there a way to lock it so the macro will still work but the users can not edit the data. Thank you |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
lock a cell from users but not macros
Try this
ActiveSheet.Unprotect Password:="MyPass" ' do things ActiveSheet.Protect Password:="MyPass" Mike "Miree" wrote: Is there a way to get this to work with a password? when i tried to do it with password it needed a user input, to unprotect, i dont want my users to have the password. Also it doesn't lock with a pass word "Per Jessen" wrote: Hi Unprotect the sheet at the top of the macro and then re-protect at the end. Regards, Per "Miree" skrev i meddelelsen ... I have a work sheet my macro copys data into. When i just protect the sheet the macro will not run. Is there a way to lock it so the macro will still work but the users can not edit the data. Thank you |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
lock a cell from users but not macros
Perfect thank you
"Mike H" wrote: Try this ActiveSheet.Unprotect Password:="MyPass" ' do things ActiveSheet.Protect Password:="MyPass" Mike "Miree" wrote: Is there a way to get this to work with a password? when i tried to do it with password it needed a user input, to unprotect, i dont want my users to have the password. Also it doesn't lock with a pass word "Per Jessen" wrote: Hi Unprotect the sheet at the top of the macro and then re-protect at the end. Regards, Per "Miree" skrev i meddelelsen ... I have a work sheet my macro copys data into. When i just protect the sheet the macro will not run. Is there a way to lock it so the macro will still work but the users can not edit the data. Thank you |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
lock a cell from users but not macros
Use this syntax:
ActiveWorkbook.Unprotect Password:="JustMe" ActiveWorkbook.Protect Password:="JustMe" Regards, Per "Miree" skrev i meddelelsen ... Is there a way to get this to work with a password? when i tried to do it with password it needed a user input, to unprotect, i dont want my users to have the password. Also it doesn't lock with a pass word "Per Jessen" wrote: Hi Unprotect the sheet at the top of the macro and then re-protect at the end. Regards, Per "Miree" skrev i meddelelsen ... I have a work sheet my macro copys data into. When i just protect the sheet the macro will not run. Is there a way to lock it so the macro will still work but the users can not edit the data. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Other users of my Excel VBA macros | Excel Programming | |||
| How do I lock a worksheet while allowing users to add comments? | Excel Discussion (Misc queries) | |||
| macros for end users | Excel Programming | |||
| how do I import macros from other users | Excel Programming | |||
| Hide Macros from Users | Excel Programming | |||
Hybrid Mode
