Hellow friends Please guide me in writing the macro 1] Whenever i open a particular file --- it start with urn macro 1 store inside this file
i have try the below mentioned macro - but it does not work out. Activate Workbook run macro 1 End Sub 2] The another macro -that do the following which ever i select the raw -- then if i run macro -- say 1 - by short cut key it automatically do for me -- select right key of keyboard --near ctrl on right side or right side mouse -- filter -- then filter by select by sell value. Thanks > > > > > > > On Sat, Oct 17, 2009 at 4:22 PM, big smile <bigsmile...@gmail.com> wrote: > >> Hellow all excel guru's & friends. >> >> I have some query -- or i want to know the shortcuts. >> >> 1] Can we delete the name given to particular cell in name box ----- if >> we type F5 - the name box appear >> >> I would like to know how to change the name and delete the name given to >> some reference. >> >> 2] There are 3 sheets in one file -- i have hide one sheet -- i want to >> know can we give the password for opening >> >> of such hide sheet ? -- if yes how >> >> 3] I have created one macro no. 7 -- in a particular file - i want to know >> can we define one another macro so that >> >> whenever i open that file -- macro no. 7 automatically run -- give me the >> result created in macro 7. >> >> 4] whenever we run a particular macro -- we can not go back by ctrl + Z [ >> undo ] -- or we can not restore the old things which were there before >> >> macro run -- is there any solution to such thing. >> >> 5] I have created certain custom view in file --- is there any shortcuts >> to change the name of that custom view --- >> >> at present i am using the technique to select the particular custom view >> -- then delete the same & then giving another name >> >> this is perhaps the long procedure.-- is there any shortcuts of changing >> the custom view name >> >> >> >> >> >> Thanks & have a nice time >> >> >> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
