Okay...so which property of the application or workbook should I use to determine if the user has enabled macros so that I know whether or not to enable the button in the workbook_open event?
I have an Excel worksheet with a command button on it that provides additional features in the worksheet. My users need to be able to see the worksheet regardless of whether macros have been disabled or not. However, if the user has disabled macros, I need to disable the button. Does anyone...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.