Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
de-selecting locked cells in protection option
Hello, I have this spreadsheet and i want to protect certain ranges of cells and the others I want to un protect. But everytine I go to Tools>protection and I uncheck the locked cells the unlocked cells gets uncheck as well. This only happens to a certain spreadsheet. I hope that I am clear...- bayuga
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Protecting ranges of Cell
Can anyone tell me how I should go about protecting a range of cell? I tried to: protect the sheet and unchecked the locked cells but did not work.It protected other cells that I did not want protected.- bayuga
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
Need Help with Automating Excel Spreadsheet
Hello, I have a spreadsheet with about 10 worksheets and 1 is the master list sheet. The other 9 sheets are by managers (let's call these sheets manager 1 - 9 sheet )which is used to make changes or additions to data. My question is, how can I make the spreadsheet to where when one goes into...- bayuga
- Thread
- Replies: 6
- Forum: Microsoft: Office
-
VBA Codes Needed for Excel
I have a workbook with about 10 sheets. 1 sheet is the main table and the other 9 are for teams. Let me back up. The main sheet has the team members name and their team manager next to their name. The other 9 sheets is by Team Manager. Now the main sheet needs to be protected at all times...- bayuga
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
