hi Guys,
I got 1 excel template that retrieve information real time from SQL server. to avoid information leaking, would like to find out is there anyway to disable the save and print button in excel ? appreciate your help.
Chow
hi Guys,
I got 1 excel template that retrieve information real time from SQL server. to avoid information leaking, would like to find out is there anyway to disable the save and print button in excel ? appreciate your help.
Chow
To prevent saving, try this code (Must be placed in the 'This Workbook' module):
-MooPlease Login or Register to view this content.
great, it works now. 1 more stuffs, how to disable user to perform cut and paste in excel worksheet ? i put in the code as follow, it only disable user to perform copy and paste, and NOT cut and paste ? so how ?
Private Sub Workbook_Activate()
Application.CutCopyMode = False
Application.OnKey "^c", ""
Application.CellDragAndDrop = False
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks