ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   enable/disable macro's dialog? (https://www.excelbanter.com/excel-programming/274791-re-enable-disable-macros-dialog.html)

Trevor Shuttleworth

enable/disable macro's dialog?
 
Josh

the traditional way around this is to have a "start up" sheet that tells the
user to enable macros. Then hide all the other sheets. In your workbook
open code you unhide the other sheets and hide your start up screen. When
you close, you reverse the process. No macros and all you get is the start
up screen. You need to protect the VBA project so they can't get at the
code. Not infallible but it will stop the day to day user.

Regards

Trevor


"Josh Ashcraft" wrote in message
...
is there anyway to get rid of this for one workbook? I
don't want the users to be able to disable the macros at
startup of this workbook.
Josh





All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com