Or simply use data validation with a list of sheet names and select the one to
show and tie to a worksheet_Change event
From: Rajan_Verma
Sent: Tuesday, August 23, 2011 2:00 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need help in maro
Hi Prasad,
Ashish’s Code working
Hi Prasad,
Ashish's Code working fine..See the attached Sheet.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Suryaprasad
Sent: Tuesday, August 23, 2011 10:56 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help in maro
Hi All,
:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help in maro
add this macro to each box
Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
' method 1 in this u have to change the shape names as per the sheet names
'Fo
add this macro to each box
Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
' method 1 in this u have to change the shape names as per the sheet names
'For i = 2 To Sheets.Count
'Sheets(i).Visible = True
'If Sheets(i).Name <> Application.Caller Then
'
'Sheets(i).Vi
