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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro in excel 2007 8
Excel macro error when workbook is shared 0
Subtotal macro in each worksheet 13
Run macro from active workbook whose name keeps changing 20
MAKE SUBTOTAL APPLICATION ON AND OFF IN MACRO 2
Open event failing 7
Want to blank some cells when an AutoFilter is active. 9
Shared Workbook Crash 0

Back
Top