prevent the users from making changes to the excel report

[Puneet]

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.
Use of macro is strictly not allowed.
Please help.
Thanks in advance

 

[Gord Dibben]

As long as users can access your Excel workbook they can defeat any security
you place on it to prevent copying or saving as a new name or simply
extracting data by opening a new book and creating links.

Save As a PDF


Gord Dibben MS Excel MVP