VBA Issue - Request and approval via e-mail

B

Billb

A request and approval process -

I have a VBA macro which selects a single sheet from a workbook an
submits (via email) that sheet to a known recipient using a contro
button. Another macro/ control button on the received sheet allows th
recipient to forward the sheet on approval to the group responsible fo
carrying out the work.

My problem is that I can't get the VBA code to follow the extracte
worksheet, so the approval fails on the original workbook not bein
available.

Any way around this?

Thanks is advance
 
J

JR

I'm just fishing here, but could you perhaps instead of
mailing the sheet, first copy the sheet to a control
workbook that has the macro code in it and then mail it?
(of course your email recipients will have to deal with
being able to receive a spreadsheet with a macro - a
security risk for systems guys)
Just a thought...
jr
 
Top