Thread: sending active sheet by mail without macro (from Ron's page)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] chip.gorman@gmail.com is offline
external usenet poster
  
Posts: 29
Default sending active sheet by mail without macro (from Ron's page)
On Nov 8, 3:09 am, Dan wrote:
Hi,
I am using Ron's Mail_ActiveSheet()http://www.rondebruin.nl/mail/folder2/mail2.htm

nut it is sending the sheet with the macro/vba - can it be sent without the
macro/vba?

Many thanks.
Dan

Befo

With Destwb

insert:

With Destwb.VBProject.VBComponents
.Remove VBComponent:=.Item("Module1")
End With

subbing the name of the module you want to delete for "Module1"

You'll have to tell your computer to trust access to vb components.
See http://support.microsoft.com/kb/282830 for how to do that.

Reply With QuoteReply With Quote