Hi BigSmile - Keep Smiling:- Below are the answers to your queries (using Excel 2003):-
1) Yes, you can delete that name. Go to Insert ->Name-> select the name and press delete. Change of name is not allowed, but Yes you can make a copy of that name and rename that as per your choice 2) Yes, You can password to workbook by choosing path:- Tools -> Protection -> Protect Workbook. If you protect the workbook, then no one can unhide that sheet, if password is not know to him/her. 3) Yes, you can use "workbook_open" event to write that macro with a "Call" option or reference option. 4) After running the macro, you should close the Excel and say no to save option provided If you have not written "Save" syntax in the code. 5) Re-naming option for custom view is not there, alternatively you should try and record/ develop a macro to do this lengthy task for you. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/17/09, 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 -~----------~----~----~----~------~----~------~--~---
