I have a piece of code via Ron De Bruin that e-mails out a worksheet.
It works great except for one small issue, the Security Dialog box
appears (Yes / No / Cancel) within Outlook. I wish to see this appear
on the face of my Excel spreadsheet.

How would I 'activate' my Excel spreadsheet file i.e. the last command
line within my code? I hope I'm using the correct terminology to
describe what I require.

Thanks

http://www.dimastr.com/redemption/

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sean" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a piece of code via Ron De Bruin that e-mails out a worksheet.
> It works great except for one small issue, the Security Dialog box
> appears (Yes / No / Cancel) within Outlook. I wish to see this appear
> on the face of my Excel spreadsheet.
>
> How would I 'activate' my Excel spreadsheet file i.e. the last command
> line within my code? I hope I'm using the correct terminology to
> describe what I require.
>
> Thanks
>