Read Only Prompt  
Author Message
Cuneyt





PostPosted: Wed Sep 26 07:08:05 PDT 2007 Top

Excel Misc >> Read Only Prompt

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!

Excel11  
 
 
PranavVaidya





PostPosted: Wed Sep 26 07:08:05 PDT 2007 Top

Excel Misc >> Read Only Prompt I am not sure which Excel version you have..however if you have 2003 then you
should do this..

On the file 'Save As' dialog box you have a menu option as 'Tools'. Under
this option select 'Save Options' and select 'Read only recommended'.

This will always prompt the user whenever they open the file.

Hope this helps!!
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!




> 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!
 
 
Gord





PostPosted: Wed Sep 26 08:04:18 PDT 2007 Top

Excel Misc >> Read Only Prompt File>Save As>Tools>General 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




>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!