shajueasow
Well-known Member
- Joined
- Oct 7, 2004
- Messages
- 1,926
Hi,
I have a macro assigned to a button that unhides the columns F:K.
The Caption on the Button is "Display Details". Is there a way to change the caption to "Hide Details" if the Columns F:K are shown and assign a macro that hides these columns to the same button.
ie, if the Columns F:K are hidden, then the caption must be "Display Deatils" and if the Columns F:K are shown, then the caption must be "Hide Details"
Hope it is clear
TIA
I have a macro assigned to a button that unhides the columns F:K.
The Caption on the Button is "Display Details". Is there a way to change the caption to "Hide Details" if the Columns F:K are shown and assign a macro that hides these columns to the same button.
ie, if the Columns F:K are hidden, then the caption must be "Display Deatils" and if the Columns F:K are shown, then the caption must be "Hide Details"
Hope it is clear
TIA