Re: $$Excel-Macros$$ How to protect macro code with a password?

2013-12-14 Thread xlstime
In the Visual Basic Editor, Tools > VBAProject Properties > Protection tab. . Enjoy Team XLS On Sun, Dec 15, 2013 at 8:41 AM, rpm wrote: > Hi, > > Pls help me to protect my code with a password...! > > > Regards, > Roshan Mathew > > -- > Are you =EXP(E:RT) or =NOT(EX

$$Excel-Macros$$ How to protect macro code with a password?

2013-12-14 Thread rpm
Hi, Pls help me to protect my code with a password...! Regards, Roshan Mathew -- 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, acc

$$Excel-Macros$$ copying data from another workbook

2013-12-14 Thread Our Ned
Hi ! I have two Workbooks 1. Main (where I have a button and I intent to write code and paste the data) 2. Data (where I have data to be copied) My code so far Sub copy() Dim wbData As Workbook Dim wbMain As Workbook Set wbData = Workbooks.Open("path") Set wbMain = Workbooks.Open("path")

$$Excel-Macros$$ Need a professional MIS Report.....

2013-12-14 Thread Indrajit $nai
Hi Experts, I have a report (excel file) that shows the number of calls by hour over the last 6 weeks. I would like this rolled up and broken down to show the percentage of weekly call volume broken down by hour per day. Essentially, take an average of every hour for the 6 weeks and then put that

$$Excel-Macros$$ Update Resords

2013-12-14 Thread Rupesh Patil
Dear Sirs How to update record in sheet using userform -- Thanks and Regards, Rp. -- 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,

$$Excel-Macros$$ problem

2013-12-14 Thread SUDHIR VERMA
Dear All, i am suffer problem in excel, when i type any key then generate Urdu word. please resolve this. -- 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

Re: $$Excel-Macros$$ Sharepoint

2013-12-14 Thread B.N.Chethan Kumar
Please help. On Dec 14, 2013 1:58 AM, "bhupendra singh raghav" < raghav.bhupen...@gmail.com> wrote: > Yes > On Dec 14, 2013 1:56 AM, "B.N.Chethan Kumar" > wrote: > >> Hi. >> I am upload excel file to a SharePoint portal. In a day close to 100 file >> need to be upload at different folder. Any mac