Unprotecting Sheets with VBA and IRM
 

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.

Unprotecting Sheets with VBA and IRM
 

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

NickHK

"Howard" wrote in message
ups.com...
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.