Emailing an Excel Sheet

alexb · Mar 11th, 2002, 01:17 PM

I have a work that I have created a macro to go with.

The macro cuts and pastes 1 of the sheets into a new workbook that I can email to a customer without him seeing the other sheets. However, when I email it internally (to check it works) my mate comes up with a prompt that says "this information is linked to another workbook - Do you want to update yes or no". If he clicks Yes it reverts back to the wrong priceing, customer name etc... How can I stop him haveing the prompt?

It is fine before he clicks yes...

alexb · Mar 11th, 2002, 01:18 PM

I ment workbook not work in my first line - I guess you all sussed this already though...

Jack in the UK · Mar 11th, 2002, 02:08 PM

HI

Can i suggest you use search on this site a great pal Chrid D (Davidson) has worked on this and posted a few good tips, others have added aswell.

Must be worth a look..... Check out Chris tip on cell A1 dummy link please delete that seem to test and work well im told

Mar 11th, 2002, 02:08 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	HI Can i suggest you use search on this site a great pal Chrid D (Davidson) has worked on this and posted a few good tips, others have added aswell. Must be worth a look..... Check out Chris tip on cell A1 dummy link please delete that seem to test and work well im told __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 01:17 PM	#1
alexb New Member Join Date: Mar 2002 Posts: 17	I have a work that I have created a macro to go with. The macro cuts and pastes 1 of the sheets into a new workbook that I can email to a customer without him seeing the other sheets. However, when I email it internally (to check it works) my mate comes up with a prompt that says "this information is linked to another workbook - Do you want to update yes or no". If he clicks Yes it reverts back to the wrong priceing, customer name etc... How can I stop him haveing the prompt? It is fine before he clicks yes...

Mar 11th, 2002, 01:18 PM	#2
alexb New Member Join Date: Mar 2002 Posts: 17	I ment workbook not work in my first line - I guess you all sussed this already though...