Is there a way you can set up a workbook so that when it opens it always
'enables macros' and doesn't give the user the option to disable?

I only want this to apply to a specific workbook (not everything I
open)

Thanks


--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=545832

Its possible to allow all macros to run by setting your "Tools" /
"Macro" / "security" settings to low but its not possible to choose to
which workbook.
The security settings you set for Macros will apply to all excel
worksheets.


--
Portuga
------------------------------------------------------------------------
Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385
View this thread: http://www.excelforum.com/showthread...hreadid=545832

ExcelBob wrote:
Is there a way you can set up a workbook so that when it opens it
always 'enables macros' and doesn't give the user the option to
disable?

I only want this to apply to a specific workbook (not everything I
open)

Thanks

If you digitally sign the macros, then a user can once accept your signiture
and from then on they will not get the message for any of the files that you
create and sign.