ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

3 Q & A posts tagged with protect

Nov 16

How to protect MS Publisher 2003 file with password?

I want to protect my MS Publisher file with a password so that no one except me could open it. Pl answer to ques with steps.


You can always use any Zip app to compress it with password

or, create a protected drive using TrueCrypt that holds these files

Get a free zip app from
and TrueCrypt from

Wednesday 11/16/2011 9:09:44 AM
Apr 26

In Microsoft Excel, how does protecting a worksheet affect the autofilter function?


In the Protect Sheet dialog, you can select what the user can do

You can select any of the checkboxes in the List including
1- Sort a table
2- Filter table (Show/Hide rows)
3- Select cells


Sunday 4/26/2009 4:36:54 PM
Apr 21

How to disable save as option in excel & Word?

How to disable save as option in excel & Word, to protect the file from copying. But the Respective person should have the option available.


In Excel 2003, put this VBA code in "Workbook" object after you press ALT+F11
Private Sub Workbook_Open()
End Sub

Then Add "Module" and paste this in
Sub disblesaveas()
CommandBars("File").Controls("Save As...").Enabled = False
End Sub

Then close the file and open it again

If you have Excel 2007, (You can also do this in Excel2003) do this
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then Cancel = True
End Sub

Good luck


Tuesday 4/21/2009 8:50:19 AM