Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
To all 3 replies. Thanks for the instruction. I will try this today. Hope
it works. But it sure was easier in SuperCalc. All you did was select the cell/s, then click "protect". That was it. This is like traveling from Houston to L.A. by way of NY. <g PS: to add to the sheet each week now, do I have to unprotect the file each time then protect again? "ed" wrote: In the cells you want protected go to the Format Menu and Format/Cells/Protect and/or Hidden You can mark as many cells as you want in one operaation. Then protect the worksheet. Only the cells you formatted will be Hidden/Protected. ed cells in my Excel spreadsheet. The old SuperCalc allowed me to protect my formulas so i could not accidentally overwrite or delete them. I've tried many times to figure it out. it only allows me to protect a whole file. this is usless to me. Please change this feature or let me know how. Thanks. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I protect only the highlighted cells in Excel? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
How do I protect specific cells from changes in Excel? | Excel Discussion (Misc queries) | |||
how do you create drop down menus for individual cells in excel? | Excel Worksheet Functions |