I am trying to automate a process which has an excel macro as part of the process. The issue is the macro prompts for enabling macros or disable macros -- so its sitting there waiting for user input. How can I default this to "enable macros" or click the enable button.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I default an access macro to "enable macros" automating it.
- Thread starter colezpapa
- Start date
- Thread starter
- #2
SkipVought
Programmer
Hi,
YOU can't.
It is a built-in security issue. It's totally up to the user to enable macros or not.
If you want to FORCE the user, so to speak, then make VERY HIDDEN, all sheets except for a splash sheet. If the user does not enable macros, then all thy can see is this one sheet. If they enable macros, then in the workbook open event, make the very hidden sheets visible, AND reset the very hidden sheets in the beforesave event.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
When a diminutive clarvoyant had disappeared from detention, headlines read...Small Medium at Large
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Status
Similar threads
- Locked
- Question