Pls help me out with Share Workbook

T

ToMMie

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
 

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

How 2 do expand/collapse Groupped Columns after worksheet protecti 1
Group of column can't be expanded or collapse after I set a protec 1
Locking Pages and/or Workbook 1
Microsoft 2007 Excel - Share Workbook Error 2
Lock cells in a shared workbook 1
Pls help on Shared WorkBook 1
Locking cells in a shared workbook 2
Workbook protection 2

Top