View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Read Only Prompt

FileSave AsToolsGeneral Options.

Checkmark in "read only".

Note: user will get a message when opening the workbook.

User can choose to open as readonly or not readonly.

Is that what you want?


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 07:02:01 -0700, Scott
wrote:

I would like an Excel file to ask the user whether they would like to open a
file as read only when they open the file. How do I go about doing this?
Thanks!