| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros in Shared Workbook | Excel Discussion (Misc queries) | |||
| Can macros be viewed or edited while in shared mode in Excel 2007? | Excel Programming | |||
| Macros in shared Workbook. | Excel Programming | |||
| Shared Workbook and Macros | Excel Programming | |||
| Macros in Shared Workbook | Excel Programming | |||
Hybrid Mode
