File Opens in Design Mode in Microsoft Office
Does your Word or Excel file open with the Control Toolbox on it, showing
you that you're in Design Mode?
This is caused by opening a file that is designed to run macros, and macros
have not been enabled.
To enable macros, go to Tools®Macro, Security tab
and set Macro security to medium (recommended if you know that the files you
receive are from trusted sources) or low (recommended only for advanced users or
for users who only use files internal to their company).
As a person who develops macros, you can keep Design view from opening when
users open your files, whether they enable macros or not, by closing Design view
on the Control Toolbox before saving your file.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved