Hi Ashish, I am getting an error while running the code which was given below could you please send me the worked attchment plz
Thanks Prasad Sent from BlackBerry® on Airtel -----Original Message----- From: ashish koul <koul.ash...@gmail.com> Sender: excel-macros@googlegroups.com Date: Tue, 23 Aug 2011 11:35:59 To: <excel-macros@googlegroups.com> 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 'For i = 2 To Sheets.Count 'Sheets(i).Visible = True 'If Sheets(i).Name <> Application.Caller Then ' 'Sheets(i).Visible = False ' 'End If ' 'Next ' method 2 For i = 2 To Sheets.Count Sheets(i).Visible = True If Sheets(i).Name <> ActiveSheet.Shapes(Application.Caller).TextFrame.Characters.Text Then Sheets(i).Visible = False End If Next Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub On Tue, Aug 23, 2011 at 10:56 AM, Suryaprasad <suryaprasad...@gmail.com>wrote: > Hi All, > > I was trying to write a macro which is not working well, attached is the > sheet where is require a small code the below is the what i require: > > I have a main sheet which is assgined with controls and i have 5 TABS , > what i want is when i click on the first control named with Sheet1 in the > main TAB then the sheet1 should open automatically and the rest of the 4 > TAB's should be hidden and the same logic should be applicable for all the > other controls , please help > > Thanks > Prasad. > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> http://akoul.posterous.com/ *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
