ExcelBanter - Excel 2007 prompt to open file as read only

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2007 prompt to open file as read only (https://www.excelbanter.com/excel-discussion-misc-queries/257989-excel-2007-prompt-open-file-read-only.html)

SEllis

Excel 2007 prompt to open file as read only

I would like an Excel 2007 file to prompt the user to open a file as read
only. How do I do this? Thank you!

Dave Peterson

Excel 2007 prompt to open file as read only

If you want the user to see a prompt, open the file.
Do a SaveAs
Click Tools|General options|and check "read-only recommended"

They can still answer "no" to this prompt, right?

SEllis wrote:

I would like an Excel 2007 file to prompt the user to open a file as read
only. How do I do this? Thank you!

--

Dave Peterson

All times are GMT +1. The time now is 12:59 PM.