Hellow Sir / Friends, - & Dilip Pandeyji
Thanks for giving the answer to my query. & advice for keep smiling, I will be grateful to you if i get the answer to this query by keeping excel 2007 version as there are lot of difference to excel 2003 version. [ if possible ] 1] in Excel 2007- in Formula - name manager - we can change / edit the name 2] i have tried the option to hide single sheet in worksheet - open only with password but that does not work -- i think i have some problem to understand - please elaborate this answer for excel 2007 version. 3] i am new to macro -- if possible can you just write the macro -- that whenever i open the workbook - that particular macro automatically run. -- i does not understand where to get the code --- you can use "workbook_open" event to write that macro with a "Call" option or reference option. 4] & 5] i understood Thanks once again. On Mon, Oct 19, 2009 at 7:43 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
