Excel 2013 Open a file and prompt user with "Author would like you to open as read-only"

excel excel-2013
mHelpMe picture mHelpMe · Mar 24, 2014 · Viewed 15.1k times · Source

I have an excel file. When the file is opened I would like the user to be prompted with the message "The author would like you to open file_abc.xlsm as read-only unless you need to make changes. Open as read-only?"

For the life of me I can't find the box to tick. What's even worse is I did this about two weeks ago from some of my other workbooks. Can someone please tell me where the option is located in Excel 2013?

Thanks!

Answer

effone picture effone · Mar 24, 2014

While saving the excel file (or 'Save As' for already saved files) when the Browse window appears asking file name, type, location etc : there is a 'tools' dropdown select just at the left of the save button. Click on it and select: 'General Options'. A mini option window appears with 'Backup Creation' / 'Password Protection' and a check box called 'Read Only Recommended'. Check that option and save your file. Thats all.

How is it related to any programming, by the way?

Related questions

If two cells match, return value from third

Here's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: Email Address associated with an order number Column C: List of 100 specific order numbers that I need the email address for So, …

Read More
Excel: Searching for multiple terms in a cell

I use this handy equation to search for a term inside of a cell in excel. =IF(ISNUMBER(SEARCH("*Gingrich*",C1)),"1","") This equation searches for the presence of Gingrich in C1, if it exists, it displays a 1. All I'd like …

Read More
Clear contents and formatting of an Excel cell with a single command

If you want to clear the contents of a cell or range in Microsoft Excel, you can use .ClearContents. If you also want to clear the formatting, you can use .ClearFormats. Sheets("Test").Range("A1:C3").ClearContents Sheets("Test").Range("…

Read More