Ungroup and Worksheet Change

A

Agamemnon

Board Regular
Joined
Sep 8, 2003
Messages
113
Hi,
I have a worksheet with columns A to F grouped together. On this particular worksheet the row and column headers are not visible.
Now I was wondering if it's possible to make a Worksheet_change macro that makes the row and column headers visible when I click on the '+' to ungroup the columns A to F.

Thx for helping me out,
Aga
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
You must log in or register to reply here.

Similar threads

M
  • Question Question
VBA Subtotal 47,000+ Rows
Replies
1
Views
190
igold
igold
G
  • Solved
VBA to allow grouping +- after reopening of the sheet
Replies
7
Views
1K
Greenbehindthecells
G
W
  • Question Question
Move Row to Another Sheet Based on Multiple Cell Values
Replies
9
Views
407
jolivanes
jolivanes
P
  • Question Question
Showing Worksheets Problem
2
Replies
18
Views
442
Alex Blakenburg
A
P
  • Question Question
Trying to do custom sort in VBA
Replies
7
Views
314
MARK858
MARK858

Forum statistics

Threads
1,222,562
Messages
6,166,804
Members
452,073
Latest member
akinch

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top