close

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 meNitin K Goyal
Here's a simple code that you can use so somebody cannot save the
workbook in excel
I got this from J.Walk's VBA for dummies

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI Then
MsgBox quot;You Cannot Save this workbookquot;
Cancel = True
End If
End Sub

you may have to go to a windows group to find out other answers, also
do a search in the groups, that's why these strings are archieved.
Dave--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=516524

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()