Command Button Macro to Expand/Collapse Grouped Columns
 

Good Afternoon,
I'm not sure if this is possible but, what I'm trying to do is instead of
users seeing and using the +/- to expand column groups I'd like to use
command buttons and turn off the view of the groupings....An additional nice
feature of the button macro would be to unprotect/protect the sheet.

I appreciate any help you can offer in advance...

Respectfully,
Sam

Command Button Macro to Expand/Collapse Grouped Columns
 

Sub cmdBtn()
Range("B:C").Columns.ShowDetail = False
End Sub

Try this: this is assuming column "A" has the +/- and column "B" and "C' are
part of that group.
"George" wrote:

Good Afternoon,
I'm not sure if this is possible but, what I'm trying to do is instead of
users seeing and using the +/- to expand column groups I'd like to use
command buttons and turn off the view of the groupings....An additional nice
feature of the button macro would be to unprotect/protect the sheet.

I appreciate any help you can offer in advance...

Respectfully,
Sam

Command Button Macro to Expand/Collapse Grouped Columns
 

Ayo Thank You for your response...My scenerio is a little different and if
you can give me a little more direction...The +/- is on Column "K" and
Columns "B -J" are part of the group...

Thanks Again.

"Ayo" wrote:

Sub cmdBtn()
Range("B:C").Columns.ShowDetail = False
End Sub

Try this: this is assuming column "A" has the +/- and column "B" and "C' are
part of that group.
"George" wrote:

Good Afternoon,
I'm not sure if this is possible but, what I'm trying to do is instead of
users seeing and using the +/- to expand column groups I'd like to use
command buttons and turn off the view of the groupings....An additional nice
feature of the button macro would be to unprotect/protect the sheet.

I appreciate any help you can offer in advance...

Respectfully,
Sam

Command Button Macro to Expand/Collapse Grouped Columns
 

Try
Sub cmdBtn()
Range("B:J").Columns.ShowDetail = False
End Sub


"George" wrote:

Ayo Thank You for your response...My scenerio is a little different and if
you can give me a little more direction...The +/- is on Column "K" and
Columns "B -J" are part of the group...

Thanks Again.

"Ayo" wrote:

Sub cmdBtn()
Range("B:C").Columns.ShowDetail = False
End Sub

Try this: this is assuming column "A" has the +/- and column "B" and "C' are
part of that group.
"George" wrote:

Good Afternoon,
I'm not sure if this is possible but, what I'm trying to do is instead of
users seeing and using the +/- to expand column groups I'd like to use
command buttons and turn off the view of the groupings....An additional nice
feature of the button macro would be to unprotect/protect the sheet.

I appreciate any help you can offer in advance...

Respectfully,
Sam

Command Button Macro to Expand/Collapse Grouped Columns
 

Ayo,

I thought the same as you but I get an error message stating "Unable to set
ShowDetailproperty of the range class"...Any Idea's

Thanks

"Ayo" wrote:

Try
Sub cmdBtn()
Range("B:J").Columns.ShowDetail = False
End Sub


"George" wrote:

Ayo Thank You for your response...My scenerio is a little different and if
you can give me a little more direction...The +/- is on Column "K" and
Columns "B -J" are part of the group...

Thanks Again.

"Ayo" wrote:

Sub cmdBtn()
Range("B:C").Columns.ShowDetail = False
End Sub

Try this: this is assuming column "A" has the +/- and column "B" and "C' are
part of that group.
"George" wrote:

Good Afternoon,
I'm not sure if this is possible but, what I'm trying to do is instead of
users seeing and using the +/- to expand column groups I'd like to use
command buttons and turn off the view of the groupings....An additional nice
feature of the button macro would be to unprotect/protect the sheet.

I appreciate any help you can offer in advance...

Respectfully,
Sam