Thread: Enable Macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default 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.