Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print and Email Function on spreadsheet
I am using Excel 2000.
I have a workbook that has been created to generate trouble tickets. It has two sheets one with the general iformation and the other being a code & formula sheet (that is hidden). The Sheets are protected to prevent typos in wrong palces and the whole workbook is also protected, against those who should know better! My problem now is, that when the workbook gets emailed to the corresponding person, their anti virus blocks password protected files. IWhat I would like to do is place a command button on the general information sheet that , when pressed, prints out the first sheet and emails a copy of the sheet (not the entire book) onwards. Can this be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print and Email Function on spreadsheet
Look at
http://www.rondebruin.nl/mail/add-in.htm -- Kind regards, Niek Otten "Samwar" wrote in message ... I am using Excel 2000. I have a workbook that has been created to generate trouble tickets. It has two sheets one with the general iformation and the other being a code & formula sheet (that is hidden). The Sheets are protected to prevent typos in wrong palces and the whole workbook is also protected, against those who should know better! My problem now is, that when the workbook gets emailed to the corresponding person, their anti virus blocks password protected files. IWhat I would like to do is place a command button on the general information sheet that , when pressed, prints out the first sheet and emails a copy of the sheet (not the entire book) onwards. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do I get a print error light trying to print an excel sheet ? | Excel Discussion (Misc queries) | |||
excel 2003 changing saved print settings | Excel Discussion (Misc queries) | |||
email print area | Excel Discussion (Misc queries) | |||
How do I print excel doc from an email | Excel Discussion (Misc queries) | |||
How do I print excel doc from an email | Excel Discussion (Misc queries) |