MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Macro's In Excel

  Asked By: Ashan    Date: Mar 17    Category: MS Office    Views: 1473

I'm trying to attach a macro in Excel so that I can email a
document to someone. but when they open the document the macro is
gone. is there a way to have it stay on?

I created a button and whoever clicks on the button the macro would
automatically run. Could someone please help me to figure this out.



2 Answers Found

Answer #1    Answered By: Shannon Freeman     Answered On: Mar 17

We may be having some trouble with terminology here.
"Attach a macro  in Excel".... "email a document"...

Are you saying that you have an Excel file.
It has a button  which executes a macro.
But when you send the Excel file to someone via email, the
macro is not present?

Probably that means that you recorded (or created) the macro
in your Personal workbook instead of the Excel file itself.

check in your VBA editor...

Another possibility is that the person that received your file
has their security set to HIGH, or Medium and then selected to
"disable macros" when the prompt came up. Either way, NO macros
will not run  if the user does this. You may have to educate the

Answer #2    Answered By: Hubayshah Mansour     Answered On: Mar 17

I think the problem might be that the recipient has their security set
to high. If they set their security to medium they will have a choice
of enabling or disabling the macro. Have them go to
Tools>Macro>Security and check the setting.

Didn't find what you were looking for? Find more on Macro's In Excel Or get search suggestion and latest updates.