Re: $$Excel-Macros$$ Time Tracking Tracker

Hi Paul, I am able to use your VBA Code properly. Just have one quick question, I need to send this to team members and do not want them to know the Password to unprotect so there will be no tampering of data. In your code you have mentioned pwd = "Test" in 4th line which can be accessible by an

$$Excel-Macros$$ Re: Most helpful member award stopped.

Hello, I'm a newbie... thanks for all contributions... nuchamber :) * On Thursday, March 7, 2013 10:54:58 AM UTC-5, Ayush Jain wrote: > Dear members, > > Thanks for your active participation and taking this group to new heights. > > This is to inform you that we are stopping the 'Most h

RE: $$Excel-Macros$$ Re: How does the Mod operator work with dates

Dear Prince Thank you very much for the reply, now it all makes sense! Much appreciated, wish all the best for you! Best Regards Jeff Wu From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prince Sent: Thursday, April 4, 2013 2:15 AM To: excel-ma

Re: $$Excel-Macros$$ Time Tracking Tracker

Thank You for the help. On Friday, April 5, 2013, Paul Schreiner wrote: > Here's what I did: > In the Sheet module, create a double-click event: > > Option Explicit > Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) > Dim pwd > pwd = "Test" > If (Target.Co

$$Excel-Macros$$POP UP

Dear Experts, I wanna create a spreadsheet, every 15 or 20 minutes it should pop up with msgbox. Is there anyway that we can create for every 15 or 20 minutes it should pop up with msgbox but without running macros evry 15 or 20 minutes For example : I have created for Good morning , Afternoo

RE: $$Excel-Macros$$ Range Solution

Hi Amar , Please find the attachment . Hope this will help you. Regards, Priti verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 05 April 2013 5:34 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Range Solution De

Re: $$Excel-Macros$$ Range Solution

Dear Amar, Pl see the solution is it ok? Warm Regards, Gawli Anil On Fri, Apr 5, 2013 at 5:33 PM, amar takale wrote: > Dear Experts > I attached Range Solution Sheet with detailed information.Pls give me > proper Guidance for Range. > Regards > Amar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:R

Re: $$Excel-Macros$$ Time Tracking Tracker

Here's what I did: In the Sheet module, create a double-click event: Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd     pwd = "Test"     If (Target.Count = 1) Then     If (Target.Value & "X" = "X") Then     If (Target.Column =

$$Excel-Macros$$ Range Solution

Dear Experts I attached Range Solution Sheet with detailed information.Pls give me proper Guidance for Range. Regards Amar -- 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/disc

Re: $$Excel-Macros$$ Please Answer the Question

Dear Team, Thank you to all. Regards karthik. On 4/5/13, Kuldeep Singh wrote: > A *Management Information System* (*MIS*) provides information that > organizations need to manage themselves efficiently and effectively.[1] > Management information systems are typically computer systems used for

$$Excel-Macros$$ Time Tracking Tracker

Hi Team, I need Time Management Tracker which does the following:- If anyone double click in start time column the time of system get capture automatically which cannot be edited , similarly for end time. Need password protected to enable changes my myself. Regards, Kaushik -- Are you =EXP(E:

Re: $$Excel-Macros$$ Please Answer the Question

A *Management Information System* (*MIS*) provides information that organizations need to manage themselves efficiently and effectively.[1] Management information systems are typically computer systems used for managing three primary components: technology, people (individuals, groups, or organiza

Re: $$Excel-Macros$$ Please Answer the Question

Hi, find below. MIS (management information systems) is a general term for the computer systems in an enterprise that provide information about its business operations. It's also used to refer to the people who manage these systems. Typical

Re: $$Excel-Macros$$ Please Answer the Question

'Management information System'. On Fri, Apr 5, 2013 at 2:14 PM, karthik N wrote: > Dear Team > > Please Answer the Question > > What is the MIS ?,Explain. > > Regards > karthik > > -- > 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 offici

Re: $$Excel-Macros$$ Please Answer the Question

Stands for Management Information System(s). Most companies have this department which caters to reporting and analysis requirements. The department sends daily / weekly / monthly / on demand / customised reports to Management regularly or as and when required. Area of work involve data collection

$$Excel-Macros$$ Please Answer the Question

Dear Team Please Answer the Question What is the MIS ?,Explain. Regards karthik -- 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, a

Re: $$Excel-Macros$$ Changing Color

Thank you very much Anil Sir and abhishek sir, Code are working fine. thanks a lot. Regards, Chaya On Fri, Apr 5, 2013 at 1:00 PM, अनिल नारायण गवली wrote: > Pl see the attached sheet. > > Warm Regards, > Just run the macro. > Gawli Anil > > > On Fri, Apr 5, 2013 at 12:57 PM, Abhishek J

Re: $$Excel-Macros$$ Changing Color

Pl see the attached sheet. Warm Regards, Just run the macro. Gawli Anil On Fri, Apr 5, 2013 at 12:57 PM, Abhishek Jain wrote: > See this. > > > On Fri, Apr 5, 2013 at 12:42 PM, Chaya wrote: > >> Thanks Abhishek Sir, >> >> Actually, where ever the colour of the D cloumn exist or the >

Re: $$Excel-Macros$$ Changing Color

See this. On Fri, Apr 5, 2013 at 12:42 PM, Chaya wrote: > Thanks Abhishek Sir, > > Actually, where ever the colour of the D cloumn exist or the > cell colour of the D column exist, the same corresponding colour should be > obtain to the corresponind row in A, B, C COLUMN. > > Say exam

Re: $$Excel-Macros$$ Changing Color

Thanks Abhishek Sir, Actually, where ever the colour of the D cloumn exist or the cell colour of the D column exist, the same corresponding colour should be obtain to the corresponind row in A, B, C COLUMN. Say example: D10 - is Green and as per condition, A10, B10 and C10 should als