| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.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! |
|
#2
Posted to microsoft.public.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!! "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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password Prompt With Read Only Option | Excel Discussion (Misc queries) | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
| Remove read only prompt | Excel Discussion (Misc queries) | |||
Linear Mode
