Macros failing when workbook is in shared mode
 

I have written a macro that does some sorting and subtotaling. It works
fine, but if I put the workbook into shared mode, it fails, telling me that
"Subtotal Method of Range Class Failed". Any suggestions on how to get it to
work?

Macros failing when workbook is in shared mode
 

Inserting automatic subtotals is one of many features which are unavailable
in shared workbooks. You can view subtotals which were added before the
workbook was put into shared mode. To insert subtotals, you will have to take
the workbook out of shared mode.

Hope this helps,

Hutch

"M Hanlon" wrote:

I have written a macro that does some sorting and subtotaling. It works
fine, but if I put the workbook into shared mode, it fails, telling me that
"Subtotal Method of Range Class Failed". Any suggestions on how to get it to
work?