Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access VBA - email spreadsheet without VBA code

Posted on 2011-03-06
3
Medium Priority
?
506 Views
Last Modified: 2012-06-27
Hi

I have a spreadsheet that contains a lot of VBA code.
How do I email this spreadsheet without the VBA?
Thanks
0
Comment
Question by:Murray Brown
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 2000 total points
ID: 35045881
If using 2007 or later then save as xlsx i.e. no code will exist in the saved worked.

Chris
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 35045883
Hmmm!

... will exist in the saved workbook which you can then send.

Chris
0
 

Author Closing Comment

by:Murray Brown
ID: 35046063
thanks very much
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question