$$Excel-Macros$$ Restrict users to edit macros but allow to view macro

2016-02-17 Thread singla.kris...@gmail.com
Hi, I have created some macros and don't want users to edit them but they should be allowed to view coding. How to do this, tried VBA Project properties option but of no use as it lock project from viewing. Appreciate your help Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Help required - alternate sorting

2015-02-07 Thread singla.kris...@gmail.com
Hi Vabz, Thank you very much That worked like wonder... Many thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate t

$$Excel-Macros$$ Help required - alternate sorting

2015-02-03 Thread singla.kris...@gmail.com
Hi, Can somebody please help me in a small macro. My sheet have a column with some values and I want to sort them alternately. Current Dr. Cr. Dr. Dr. Cr. Cr. Cr. Dr. Required Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Thanks in advance Krishan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d

$$Excel-Macros$$ Re: How to copy Excel files thru Command prompt

2009-05-05 Thread singla.kris...@gmail.com
i need to copt two or more excel files into one excel file On May 5, 8:56 pm, yogesh yerawar wrote: > Hi, > > copy filename destination path > > eg. > copy book1.xls c:\my documents > > 2009/5/5 singla.kris...@gmail.com > > > > > Hi eveybody, > >

$$Excel-Macros$$ How to copy Excel files thru Command prompt

2009-05-05 Thread singla.kris...@gmail.com
Hi eveybody, can anyone tell me how to copy excel files using command prompt. thanx in advance --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutor