Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Disable save on read only??

is it possible for me to disable the save option on a read only file. I have
a file on the network which is shared. however when people open a read only
version and save it as a copy, then peopple are opening the copy version and
updating date, resulting in lost data and a lot of double handeling!!

any help??
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default Disable save on read only??

Hi,
unfortunately if the user open as read only the file they still can save it
just changing the name. The users have to realize that doing that result in
lost data

"Gazz_85" wrote:

is it possible for me to disable the save option on a read only file. I have
a file on the network which is shared. however when people open a read only
version and save it as a copy, then peopple are opening the copy version and
updating date, resulting in lost data and a lot of double handeling!!

any help??

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default Disable save on read only??

What Eduardo said is correct. However, if macros are enables, you can provide
reminders/hindrances. For example, if you open the VBA editor (Alt+F11) and
paste this into the ThisWorkbook module, it will cause a warning message to
appear reminding people that they can't save, and then close the workbook
without actually saving.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
MsgBox "You are not allowed to save this workbook", vbOKOnly, "No Saving"
ThisWorkbook.Close SaveChanges:=False
End Sub


Note that, to set this up, you need to disable macros, write this in, and
then save. Then, re-enable macros. Otherwise, your own macro will prevent you
from saving!
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Gazz_85" wrote:

is it possible for me to disable the save option on a read only file. I have
a file on the network which is shared. however when people open a read only
version and save it as a copy, then peopple are opening the copy version and
updating date, resulting in lost data and a lot of double handeling!!

any help??

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Disable save on read only??

Hi,

You can test for read only and prevent save if it is or allow save if it
isn't. The wheels come off though if macros aren't enabled

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If ActiveWorkbook.ReadOnly Then
MsgBox "File was opened as read-only and cannot be saved"
Cancel = True
ActiveWorkbook.Close savechanges:=False
Else
MsgBox "File was not opened as read-only and can be saved"
End If
End Sub

Mike

"Gazz_85" wrote:

is it possible for me to disable the save option on a read only file. I have
a file on the network which is shared. however when people open a read only
version and save it as a copy, then peopple are opening the copy version and
updating date, resulting in lost data and a lot of double handeling!!

any help??

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable Do you want to save changes sb1920alk Excel Discussion (Misc queries) 2 May 29th 08 08:36 PM
Disable Save/Save As - not working? Silena K-K Excel Discussion (Misc queries) 3 December 11th 07 04:09 PM
Disable Quick Save & Save As L Weber Excel Discussion (Misc queries) 6 October 18th 07 08:57 PM
Disable save nobbyknownowt Setting up and Configuration of Excel 1 February 14th 07 09:18 PM
Disable save nobbyknownowt[_2_] Setting up and Configuration of Excel 0 February 13th 07 04:53 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"