Does anyone know of a way to prevent a user from opening a workbook if they disable macros?
Does anyone know of a way to prevent a user from opening a workbook if they disable macros?
Check out the KB for some suggestions.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Trombre, it is not possible to stop them opening the workbook if macro's aren't enabled but it is possible to prevent functionality and force a blank page to be displayed. Look at this Kb item
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Is the suggested code xL 5.0 compatible?