Is there any way to write this code to excel from VB6
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
Actually my problem is
I have an application written in Visual Basic 6. My application
creates a Customer Details Report in Excel. All done till here but now
my problem is that I want to prevent the users from making changes to
the excel report or to copy/paste/delete data from my report or to
save file as another name.
I tried protecting the sheet but that only solves half of the problem,
user can still save file as another name and copy the data.