Hi Rajan,

Thanks for the Macro, but i need somethig like this :

I have 5 TAB's in the first TAB named with Sheet1 i have Control as Sheet2
the point here is once i work on my sheet1 then i need to go to Sheet2 so i
have placed a control as sheet2 (something like hyperlink)and once i click
on sheet2 control the sheet1 should be automatically hidden and sheet2
should be active and it has the control of Sheet3, and again the if i click
on sheet3 control then sheet2 should be hidden and sheet3 should be active ,
similalrly the same activity should happen till sheet5 which will again
bring to sheet1 please refer to the attachment which i have sent.

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

Attachment: Design_1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Reply via email to