Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a checkbox to trigger an email
I have a spreadsheet to keep track of documentation that our group
creates. The final step is for the writers to put a copy of the file into several network directories. Can I build a checkbox inserted into each row and when that box is checked, the row info is emailed to me? I don't want the entire sheet emailed, just notification that 'User Manual' or 'Load Manual' was updated. Thanks Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a checkbox to trigger an email
One solution:
1 change one of the columns to use a font showing a checkbox tick character 2 capture the Worksheet_Change event and check for a tick or no tick then call (or not) your email functionality The ActiveX checkbox control will make all this a little easier by providing a change event but this probably isn't what you want given your description. To get your checkbox: Format the required cell range using the 'Webdings' font and insert the letter 'a' where you want a check to appear. http://www.billlunney.com/Excel/FAQ/...ExcelFAQID=137 There are other solutions too. -- Regards, Bill Lunney www.billlunney.com "Chris" wrote in message om... I have a spreadsheet to keep track of documentation that our group creates. The final step is for the writers to put a copy of the file into several network directories. Can I build a checkbox inserted into each row and when that box is checked, the row info is emailed to me? I don't want the entire sheet emailed, just notification that 'User Manual' or 'Load Manual' was updated. Thanks Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CheckBox doesn't show in Email | Excel Discussion (Misc queries) | |||
Checkbox not showing in Email | Excel Discussion (Misc queries) | |||
Email trigger | Excel Discussion (Misc queries) | |||
Why does using @SUM in EXL 2002 trigger an O/L "new" email ? | Excel Worksheet Functions | |||
Can you set a "trigger" in excel to send an email? | Excel Worksheet Functions |