Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
choose default macros Not Enabled / Macros Enable Setting | Excel Programming | |||
VBA select default Don't Enable / Enable macros Setting | Excel Programming | |||
Enable Macros | Excel Programming | |||
Enable Macros | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |