On the menu select Insert - Name - Define. You can add, change or delete range names from there.
On Oct 17, 6:52 am, 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 -~----------~----~----~----~------~----~------~--~---
