Re: $$Excel-Macros$$ Very Urgent

2014-06-19 Thread Ankur Gupta
hi vaibhav, Could you please illustrate as in what you want to tell me? The workbook is not protected but the button , i cant see the code even in design mode. It remains clickable even after entering the design mode. Is there any way i can check the code for macro written? Please advise me bette

Re: $$Excel-Macros$$ Very Urgent

2014-06-19 Thread Vaibhav Joshi
Hi Is macro module protected? if you can open WB then its not diff. to unprotect VBA module. You can google it around to know how to unprotect it. Pl note rule 3 "Don't post questions regarding breaking or bypassing any security measure." Cheers!! On Fri, Jun 20, 2014 at 10:33 AM, Ankur Gupta

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

2014-06-19 Thread Anil Gawli
Dear Ankur, Pl share the workbook with us. Warm Regards, Gawli Anil. On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta wrote: > I am new to excel and absolutely a novice to vb. I have been given a task to > write macros code in vba in excel. The macro code is already there but > nobody knows the pa

$$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

2014-06-19 Thread Ankur Gupta
I am new to excel and absolutely a novice to vb. I have been given a task to write macros code in vba in excel. The macro code is already there but nobody knows the password. So the button even in design mode doesnot show view code. I just want to view to code behind. I cant pass the sheet as it

$$Excel-Macros$$ Very Urgent

2014-06-19 Thread Ankur Gupta
I am new to excel and absolutely a novice to vb. I have been given a task to write macros code in vba in excel. The macro code is already there but nobody knows the password. So the button even in design mode doesnot show view code. I just want to view to code behind. I cant pass the sheet as it

Re: $$Excel-Macros$$ Need VBA code to track log off and log on Time

2014-06-19 Thread Paul Schreiner
That's actually not that easy to do.   The problem is that you're dealing with Windows Events. Many Windows events (login, screen locking, etc) write to a system log. but many of these are set up by the workstation "Policies".   The policies are handled by the network system administrator.   Depend

$$Excel-Macros$$ Need VBA code to track log off and log on Time

2014-06-19 Thread sunil patil
Hi All, Can you provide me vba code to track when any user lock the system, time shoud start tracking in one excel sheet when user relogin . the final output shoud be logg off time to login time., E.g suppose user lock the computer by 6:30 and log in after 6:45, time shoud be calculated as 1

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-19 Thread Vaibhav Joshi
Cheers!! On Thu, Jun 19, 2014 at 4:03 PM, SG wrote: > Thankyou so much Vabz > > > On Wednesday, June 18, 2014 8:50:04 PM UTC+5:30, Vabz wrote: > >> Chek this,,, >> >> >> On Wed, Jun 18, 2014 at 7:08 PM, SG wrote: >> >>> yeah got it...one more thing..in reports, we can't say customer to >>>

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-19 Thread SG
Thankyou so much Vabz On Wednesday, June 18, 2014 8:50:04 PM UTC+5:30, Vabz wrote: > > Chek this,,, > > > On Wed, Jun 18, 2014 at 7:08 PM, SG > > wrote: > >> yeah got it...one more thing..in reports, we can't say customer to select >> * for "All" because it's not user friendly. What to do in

Re: $$Excel-Macros$$ Display button after 10 seconds in vba

2014-06-19 Thread Vaibhav Joshi
Hi Check this file.. In sheet1 there is button 1, which will be displayed after 10 secs once sheet is activated. Cheers!! On Thu, Jun 19, 2014 at 6:23 AM, Raihan Khan wrote: > i created one button and after my workbook loads , i want my button to > appear after 10 seconds , i don't want my