Please find the attached file for solution
rather then using checkbox use ration button then it will make more sense regards Santosh Bahuguna On Wed, Jun 29, 2011 at 2:03 AM, Rash <rashmiv.ni...@gmail.com> wrote: > Hi all, > > I have some files sorted depending on department in one of my E:/ location. > Instead of going manually inside each folder I thought of automatic it > using excel. > > I assume 4 check boxes. If I select 1st check box , HR folder should open > automatically which is inside E:>/ My files/All/HR > > If i select 2nd Check box, Engineering folder should open , which is in > E:>/ My files / All /Engineering and vice versa for 6 check boxes and 6 > different folders. > > I thought of using an user form and macro it using VBA.and create > executable of it. Is it possible or any other ways are there to do it. > Please give me some inputs on this. > > Rashmi > > -- > > ---------------------------------------------------------------------------------- > 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
test.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
