Prevent Other users from pressing "Save"-button

Cowboy Henk

Board Regular
Joined
Jul 5, 2005
Messages
129
Hello again,

How can I prevent other users who use a document of mine to press the "Save"-button. Can't it just dissappear?
Any ideas on this?
Thx
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Could you not simply password protect the workbook, leaving read-only as the only option for others ?
 
Upvote 0
no, because it's a file on a shared disk and they must be able to edit the file, but there are linked objects to a Word-document in it and at a certain time, they have to break the links after they're updated and then save the file as a different file name.
 
Upvote 0
u will allow them to edit but not to save..
y dont u just give them a copy of the file? making changes is useless if it wont be saved. if u want them to save it as a different file, give them copies and forget it..
 
Upvote 0
malcom said:
u will allow them to edit but not to save..
y dont u just give them a copy of the file? making changes is useless if it wont be saved. if u want them to save it as a different file, give them copies and forget it..
Hi,
They should be able to edit the file, but not Save the file as the same name. It's a file they have to create twice a week and it has to be published on the net. The only thing they should be able to do, is to break the links and then "Save AS" and a different file name.
 
Upvote 0
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Application.DisplayAlerts = False
If SaveAsUI = False Then Cancel = True
End Sub

im not sure if this would work... You wont be able to save.. only save as..
 
Upvote 0
Hi guys,

ok, after considering, I must grant you my excuses, making the file read-only should solve the problem. The person who's making the file isn't that bright so she probably doesn't know how or where to change it.
Thx anyway for all your replies!!!
 
Upvote 0
if u just change the property to read only, it can easily be changed..
try saving it with password to modify, read only recommended...
so, it wont be over written but saved as a different filename..
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top