Macros failing when workbook is in shared mode

  • Thread starter Thread starter M Hanlon
  • Start date Start date
M

M Hanlon

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?
 
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
 
Back
Top