Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Locking Options in Excel

Status
Not open for further replies.

RonMB

Mechanical
Oct 7, 2002
24
0
0
US
Is there a way to prevent other users from changing the options in Excel? Example is to prevent a change to "Move after Enter" under the Edit tab.
 
Replies continue below

Recommended for you

Possibly the "safemode switch" in the command line...

excel.exe /s

Run Excel in this manner and see if this will work for you.
It may limit too much.

 
You can with vba inserted in the workbook open module.
Record a macro and set or unset the settings you want to stick to get the code.

-Mark
 
Status
Not open for further replies.
Back
Top