Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
secure an excel spreadsheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
secure an excel spreadsheet
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 -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - how to se Secure FTP | Excel Discussion (Misc queries) | |||
How to secure my excel sheet from others and only once use after g | Excel Discussion (Misc queries) | |||
Secure spreadsheet | Excel Discussion (Misc queries) | |||
How can I secure all tabs in excel 2003 at once? | Excel Discussion (Misc queries) | |||
How do i secure my excel with a password? | Excel Discussion (Misc queries) |