Unprotecting Sheets with VBA and IRM

H

Howard

I have an Excel file that has VB macros and it works fine with no IRM.

When I apply IRM to it and only give the users "Change" rights so they
can input data into the file, the macros start throwing error messages.

The macros use the unprotect function.

Microsoft has documented the problem, but gives no solution or
workaround. http://support.microsoft.com/kb/914199/en-us

For the most part, all my macros are doing is hiding or unhiding rows
and columns so the sheets look cleaner to the user. What is the best
way for me to do this with IRM and still lock certain cells from user
input?

Thanks in advance.

Any help or insight would be most appreciated.
 
N

NickHK

Howard,
Bit of kludge, but does not require Protection and limits entry to unlocked
cells.
Range("rngData").Select
Application.DataEntryMode = xlStrict

NickHK
 

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