Avatar of excelismagic
excelismagic
 asked on

is there a way to force user enable macro for the template i send to them

i have a template which i cannot share here, it is a excel workbook that when i sent to colleague usually they forget to enable the macro and hence they contact helpdesk that the workbook functions are not working.

is there  a way to force users to enable macro before the content and worksheets of workbook becomes visible to them?
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
excelismagic

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Shums Faruk

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
excelismagic

ASKER
thanks
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck