Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-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
Joined
Oct 7, 2002
Messages
24
Location
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.
 
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.

Part and Inventory Search

Sponsor

Back
Top