How to deal with security issues in Excel?

[arbind gaba]

I am facing lot of problems while encountering some serious security issues and other security threats in Excel. I want to protect my workbooks from external changes and unauthorized access. Also, I want to lock some sheets and cells to stop users changing the structure and formula. I have heard that by making use of macro programming I can lock various features of Excel and can avoid any security breaches.

Kindly elaborate how to implement these security issues and how to code them by using macro programming. Also, explain step wise procedure of making these changes on different workbooks and files so as to keep any unwanted changes at bay.

 

[bobhc]

Excel was never designed to be a multi user program and its security is on par with Swish cheese....Full of holes.
If you want users to input and view data the best way is to use Access and import your data into it, you can split the front end (what the user sees) from the back end (all the data) so that the user cannot interfere with the data.
As YOU update Excel you can update Access