Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User permissions for ranges
Is there any way, programmatically, to set user permissions for a range?
Basically, I want to use the functionality that exists when I go to: Tools / Protection / Allow Users to Edit Ranges ... Then, when I click on the "Permissions" Button, I can add a user or group. The assigned user or group then has permissions to modify the range without a password. Thank you, in advance, for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User permissions for ranges
Turn on the macro recorder (Tools menu, Macro, Record new macro)
while you set permissions, and you'll see the code to do what you want. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dalbin" wrote in message ... Is there any way, programmatically, to set user permissions for a range? Basically, I want to use the functionality that exists when I go to: Tools / Protection / Allow Users to Edit Ranges ... Then, when I click on the "Permissions" Button, I can add a user or group. The assigned user or group then has permissions to modify the range without a password. Thank you, in advance, for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User permissions for ranges
Thank you for your input.
Actually, though, that was the first thing I tried before making this posting. It didn't record anything pertinent. I believe the commands are nested too far into the Excel dialog boxes, that the recorder does not record what I am setting. Here is what it recorded: Sub ProtectSheetsMacro() ActiveSheet.Protection.AllowEditRanges.Add Title:="Testing", Range:=Cells, _ Password:="tennis" End Sub Please reply with any other ideas. "Chip Pearson" wrote: Turn on the macro recorder (Tools menu, Macro, Record new macro) while you set permissions, and you'll see the code to do what you want. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dalbin" wrote in message ... Is there any way, programmatically, to set user permissions for a range? Basically, I want to use the functionality that exists when I go to: Tools / Protection / Allow Users to Edit Ranges ... Then, when I click on the "Permissions" Button, I can add a user or group. The assigned user or group then has permissions to modify the range without a password. Thank you, in advance, for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use VB to set permissions for cell ranges in Excel 2K3? | Excel Programming | |||
How to know which user is having permissions on the different system folder. | Excel Programming | |||
How to get SID of user alongwith the permissions? | Excel Programming | |||
Manipulate user permissions in a worksheet using VB | Excel Programming | |||
Hiding worksheets based on user permissions | Excel Programming |