Trying to edit user permissions under "Allow user to edit ranges" using VBA

[Whizbang]

Ok, so I have this bit o' code by recording a macro

Please Login or Register  to view this content.

The only problem is that, while recording, I also set permissions specific to a user by:
1:Clicked on "Permission"
2: clicked "Add".
3:The object type and location were already entered so I entered the user id and hit ok.

This part does not reflect in the code. Does anyone know of a way to add permissions with VBA?

[Whizbang]

Nevermind. I figured it out.

Please Login or Register  to view this content.

This site gave me the info I needed:
http://books.google.com/books?id=gkP...age&q=&f=false

[Leith Ross]

Hello WhizBang,

Here is macro taken from the VBA Help Files. This will list the permissions assigned to a document (Excel Workbook).

Please Login or Register  to view this content.

[Whizbang]

Thank you Leith Ross. I get a Runtime Error '445': Object doesn't support this action

I've got the adding of permssions figured out. Now I would like to delete them. I've tried:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I just can't seem to get it to delete a user, once they've been added.

[romperstomper]

Try:

Please Login or Register  to view this content.