Unprotecting Sheets with VBA and IRM

P

Philip

I have a Excel template with VBA code that I am trying to distribute.

I want to use the IRM in Office 2003 and have given the users "Change"
rights to the sheet.

However, the macro will crash when it attempts to unprotect the sheet. If I
look further, the Unprotect option under Tools/Protection is greyed out.

Changing the access and providing the user "Full" access will solve this but
effectively defeat the purpose of enableling IRM in the first place!

Any workarounds?

Philip
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top