prevent the users from making changes to the excel report

  • Thread starter Thread starter Puneet
  • Start date Start date
P

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
 
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
 
Back
Top