Pls help me out with Share Workbook
 

My worksheet has a groupped of column and I want to expand/collapse the
groupped column after workbook protection, moreover, I want to share this
workbook as well.

I've got a very good suggestion from a guy here (Gord) for the codings in VB
editor. it allows me to expand/collapse the groupped column after I protect
workbook. but when I share the workbook, there is a runtime error everytime I
re-open file and I just can't do the expand/collapse of groupped columns.

anyone can help me with this issue?

Many thanks in advance.
Tommie