In the 'ThisWorkbook' code section of the workbook, put...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
End Sub

Of course, if they have macros set to not run, this won't work.

HTH,
Gary Brown


"looking4help" wrote:

When I post my worksheet to my website, I want the user to be able to use the
filtering functions I have in the worksheet but I don't want them to be able
to save the worksheet to their hard drive.

Is there a way that I can do this?

Thanks!
--
looking...