pls help me

J

jai

Hi every body,

I am a new member of this group.


I prepare programms in excel with the help of various functions.


Can any body tell me any way that any person not able to run the excel
sheet if he/she stolen program by any person or staff member for this
private use from my hard disk.


If i give password for opening the workbook. it is not possible because

staff members are working on that program in office.


My staff member copy the programs and misuse it.


Pls help me


Nitin K Goyal
 
D

davesexcel

Here's a simple code that you can use so somebody cannot save th
workbook in excel
I got this from J.Walk's VBA for dummies

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel A
Boolean)
If SaveAsUI Then
MsgBox "You Cannot Save this workbook"
Cancel = True
End If
End Sub

you may have to go to a windows group to find out other answers, als
do a search in the groups, that's why these strings are archieved.
Dav
 

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

Top