Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unprotecting Sheets | New Users to Excel | |||
Unprotecting Sheets | Excel Programming | |||
Unprotecting Sheets with VBA and IRM | Excel Programming | |||
PROTECTING/UNPROTECTING SHEETS | Excel Discussion (Misc queries) | |||
unprotecting sheets | Excel Programming |