secure an excel spreadsheet

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I am experience in Excel, however, I am new to the
administrative part. I would like to make a spreadsheet
available through our LAN for many people to view and make
changes, but I want to know if there is programming that
will keep that spreadsheet being saved in ONE location on
the network. Does anyone know this?

Thank you for all your help,
Christine
 
It's simple. Take a look:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,
Cancel As Boolean)
If SaveAsUI Then
MsgBox "U can't use Save As function!" & vbcr _
& vbcr & "U can use ONLY Save function",
vbCritical, "No privillages"
Cancel = True
End If
End Sub
 
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

Excel Spreadsheets keep moving 0
Excel Excel spreadsheets opening at top instead of bottom. 4
Extracting data from an excel spreadsheet 3
security constraints when you a excel scripting macro? 2
ActiveWorkbook.Save saves to wrong directory 9
Opening an Excel spreadsheet from within an Excel spreadsheet 2
Spreadsheet Security 5
Trying to create a list of prices from a web page 2

Back
Top