Is the a Way to enable macros with a macro?

I know that security will not let you, but I need to send a File with a
message box to that will explain how to fill out the spread sheet and don't
want to go to each of the explaining how to enable macros.

Send out a worksheet with an on_open macro. There should be one sheet in the
spreadsheet with instructions how to enable macros and one sheet letting them
know that there macros are enabled.

The Instructions sheet shoul be visble. The on Open macro just makes the
sheet hidden. When the user open the spreadhsst they either get a sheet
telling them how to enable macros or a sheet telling them that their machine
is set up correctly...

HTH

"MESTRELLA29" wrote:

Is the a Way to enable macros with a macro?

I know that security will not let you, but I need to send a File with a
message box to that will explain how to fill out the spread sheet and don't
want to go to each of the explaining how to enable macros.

No, because if macros are not enabled, the enabling macro won't run.

The standard way to approach this is as follows.
- create a worksheet with a message on explaining that for this workbook to
run it needs macros enabled, maybe even a few screenshots
- hide all other worksheets]
- add some code in the Workbook_Open event that un hides the other sheets,
but hides that sheet.

What happens is that if they do not enable macros, they will only see the
warning sheet, telling them how to do it. If the enable macros, it will
startup as the workbook it should be.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MESTRELLA29" wrote in message
...
Is the a Way to enable macros with a macro?

I know that security will not let you, but I need to send a File with a
message box to that will explain how to fill out the spread sheet and
don't
want to go to each of the explaining how to enable macros.