prevent saving a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
If on a website, I don't know of a method to prevent a user from right-click
and Save Target As.

Unless your website can restrict that capability?

Excel certainly can't prevent it.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent printing a sheet 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Copy Worksheet of Locked Workbook 2
Saving freeze pane worksheet 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
PREVENTING ACCESS TO A HIDDEN COLUMN 2
worksheet renames - specific 0

Back
Top