Automatically making an excel sheet
Posted on 2006-10-25
I've got everything else down, i just need to stop the user from selecting certain cells (without hiding them). In excel this is done by going through the menus like so:
Tools -> Protection -> Protect Sheet ...
The menu comes up and then you can select from the list with the label
Allow all users of this worksheet to:
|_| Select Locked Cells
|_| Select unlocked Cells
allong with others
By default, the user is allowed to select any cells even though they are protected. I need to make it in my generated xls file that the user cannot select the locked cells. How is this done?
As a note, I'm using vb6 with the office11 excel library. Thanks.