get changed rows in Excel 
Author Message
 get changed rows in Excel

HI
I have this problem,i want to send a mail with the rows a
person change i a workbook.
i have the code for sending the mail,but i can't figureout
how to get the changed rows
anyone ???

/PE



Sat, 04 Jun 2005 15:30:55 GMT  
 get changed rows in Excel
if its a simple sheet, then why not make a hidden copy. when the user has
done, compare the hidden original with the updated version.

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------

Quote:
> HI
> I have this problem,i want to send a mail with the rows a
> person change i a workbook.
> i have the code for sending the mail,but i can't figureout
> how to get the changed rows
> anyone ???

> /PE



Sat, 04 Jun 2005 15:37:50 GMT  
 get changed rows in Excel
Im new to this, so that soloution sounds like to hard for
me
Thanx anyway
/PE
Quote:
>-----Original Message-----
>if its a simple sheet, then why not make a hidden copy.
when the user has
>done, compare the hidden original with the updated
version.

>--
>Patrick Molloy
>Microsoft Excel MVP
>----------------------------------


>> HI
>> I have this problem,i want to send a mail with the rows
a
>> person change i a workbook.
>> i have the code for sending the mail,but i can't
figureout
>> how to get the changed rows
>> anyone ???

>> /PE

>.



Sat, 04 Jun 2005 15:47:13 GMT  
 get changed rows in Excel
Why not set up Sharing the workbook ( Tools/Sharing ) and track the changes
that way?

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------

Quote:
> Im new to this, so that soloution sounds like to hard for
> me
> Thanx anyway
> /PE
> >-----Original Message-----
> >if its a simple sheet, then why not make a hidden copy.
> when the user has
> >done, compare the hidden original with the updated
> version.

> >--
> >Patrick Molloy
> >Microsoft Excel MVP
> >----------------------------------


> >> HI
> >> I have this problem,i want to send a mail with the rows
> a
> >> person change i a workbook.
> >> i have the code for sending the mail,but i can't
> figureout
> >> how to get the changed rows
> >> anyone ???

> >> /PE

> >.



Sat, 04 Jun 2005 22:25:03 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Getting row number variable from a selected row in Excel

2. change excel default calculations order from row-by-row to column-by-column

3. Getting Excel To Automatically Refresh Changed VBA Scripts With A Worksheet

4. Changing Excel worksheet columns to rows

5. Linking Changing EXCEL Rows & WORD Fields

6. Changing row height in a table copied from Excel

7. Adding rows changes which rows are hidden

8. Increment row 1 when row 2 text changes?

9. Can I change text color on certain rows on multi row result set

10. Change cell-contents when changing other cells in same row


 
Powered by phpBB® Forum Software © phpBB Group