Enable Macros
 

Hi,
I wrote script which copy data from one sheet to second sheet, It's
important for this excel sheet. I used method call Auto_Open().
If I open the document, Excel ask user If he want Enable Macros.
I dont want see this dialog and Enable Macros automaticaly, Is it possible?

Enable Macros
 

Hi.

You can't do that but there are ways around it and the most common is on
closing the workbook (workbook_Before_Close) make all the sheets except one
xlveryhidden. If a user enables macros then unhide all the worksheets for use
using the workbook_Open event . If macros aren't enabled display the single
unhidden sheet containing a suitable message that the workbook is useless
unless macros are enable

Not bullet proof but not bad either.


Mike

"Martin M." wrote:

Hi,
I wrote script which copy data from one sheet to second sheet, It's
important for this excel sheet. I used method call Auto_Open().
If I open the document, Excel ask user If he want Enable Macros.
I dont want see this dialog and Enable Macros automaticaly, Is it possible?

Enable Macros
 

Ok, This is good way :) :)

"Mike H" wrote:

Hi.

You can't do that but there are ways around it and the most common is on
closing the workbook (workbook_Before_Close) make all the sheets except one
xlveryhidden. If a user enables macros then unhide all the worksheets for use
using the workbook_Open event . If macros aren't enabled display the single
unhidden sheet containing a suitable message that the workbook is useless
unless macros are enable

Not bullet proof but not bad either.


Mike

"Martin M." wrote:

Hi,
I wrote script which copy data from one sheet to second sheet, It's
important for this excel sheet. I used method call Auto_Open().
If I open the document, Excel ask user If he want Enable Macros.
I dont want see this dialog and Enable Macros automaticaly, Is it possible?