GrantLund
08-22-2006, 02:27 AM
Hi All!:hi:
Ok. I have moved everything into Excel from Word and so far so good, however, I want to protect the code and worksheets so that people can't get into the commandbutton and other control toolbox properties and edit the worksheets as well. In Word it is simple - password protect your document. In Excel, that doesn't work. I have tried protecting the sheet, the workbook and locking the objects but that doesn't work - you can still get into the code/userforms etc. How can one protect the code to stop people from editing it?:help
Second thing: I have hidden all worksheets and have a main worksheet which if you click opens up the "hidden" worksheets and hides the main worksheet and vice versa. However, when I protected the workbook with structures and windows options then get an error in the macro because it sees the unhiding as an edit function I presume. If I just click on structures OR windows options then don't get a problem with the macro. Should I just accept this level of workbook protection (ie. only either structure or window option but not both) or is there another way?:think:
Rgds
Grant
Ok. I have moved everything into Excel from Word and so far so good, however, I want to protect the code and worksheets so that people can't get into the commandbutton and other control toolbox properties and edit the worksheets as well. In Word it is simple - password protect your document. In Excel, that doesn't work. I have tried protecting the sheet, the workbook and locking the objects but that doesn't work - you can still get into the code/userforms etc. How can one protect the code to stop people from editing it?:help
Second thing: I have hidden all worksheets and have a main worksheet which if you click opens up the "hidden" worksheets and hides the main worksheet and vice versa. However, when I protected the workbook with structures and windows options then get an error in the macro because it sees the unhiding as an edit function I presume. If I just click on structures OR windows options then don't get a problem with the macro. Should I just accept this level of workbook protection (ie. only either structure or window option but not both) or is there another way?:think:
Rgds
Grant