See if it help
I have create a Toggle Button For You ..
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of bpascal123
Sent: Wednesday, July 20, 2011 4:26 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ excel user form
Hi Mahesh,
Thanks for your help.
I'not sure if my first query wasn't confusing. In between, I found
another way to deal with this query.
My first query was about having one button on let say 10 or more
sheets. Each button should be related to the same code. In other
words, button.Sheet1=>button.
Hi Pascal
Try:
Private Sub CommandButton1_Click()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Columns("A:A").Hidden = Not ws.Columns("A:A").Hidden
Next
End Sub
Thanks
Mahesh
On Sat, Jul 16, 2011 at 11:11 PM, bpascal123 wrote:
> Hi,
>
> I would like to know if there is a way to use the same
