Hey Peter,

I can disable the save once users have opened the workbook, But when they
click on intranet to launch the form they get an option to "open,save,cancel"
and they click save there. Is there any way to disable the save there?

Thanks in advance

"Peter T" wrote:

Another idea, trap the SaveAs dialog

' in the ThisWorkbook module
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
If SaveAsUI Then
Cancel = True
MsgBox ThisWorkbook.Name & " can only be saved to - " & vbCr & _
ThisWorkbook.Path
End If

End Sub

Regards,
Peter T

"sam" wrote in message
...
Hi All,

I have an excel userform that is posted on my companys intranet. The issue
I
am having is, users are saving this form to their hard drive and then
using
it(Instead of launching it everytime from intranet), SO basically when I
have a new version of form on intranet they still use the old version as
they
have a habbit of saving it on their hard drive.

Is there a way to resove this? something like they would see a popup
message
saying that "This is an older version that you are using, Please launch
the
form from Intranet for newer version".

Thanks in advance


.