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.