Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protection issues . . . HELP!
Maybe I don't quite understand the concept of "protection"???
What I did . . . I unlocked all cells in the entire workbook, a sheet at a time. (Highlighed total sheet, right clicked. Format/cell/protect/unchecked "locked") Then I went to 2 sheets and selected the cells I do not want anyone editing. Using the same steps, I "locked" the cells. I went into 'Tools'. Selected "protect Workbook". Entered my desired PW. I deselected almost all of the options. I especially don't want rows or columns inserted! Saved my worksheet. Closed it. Closed Excel. Opened it back up. I'm still able to do anything to the cells. Including deleting the formulae or all c ontents of the cells. I was not asked for a pass word, etc. I can also still insert rows and columns. :( HELP! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
protection issues . . . HELP!
Try protecting each worksheet -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=558611 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
protection issues . . . HELP!
Part 2 . . .
When I protect the worksheet, the cells containing hyperlinks no longer link. "Wayne Knazek" wrote: Maybe I don't quite understand the concept of "protection"??? What I did . . . I unlocked all cells in the entire workbook, a sheet at a time. (Highlighed total sheet, right clicked. Format/cell/protect/unchecked "locked") Then I went to 2 sheets and selected the cells I do not want anyone editing. Using the same steps, I "locked" the cells. I went into 'Tools'. Selected "protect Workbook". Entered my desired PW. I deselected almost all of the options. I especially don't want rows or columns inserted! Saved my worksheet. Closed it. Closed Excel. Opened it back up. I'm still able to do anything to the cells. Including deleting the formulae or all c ontents of the cells. I was not asked for a pass word, etc. I can also still insert rows and columns. :( HELP! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
protection issues . . . HELP!
I think I got it! Thanks!!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code error with Protection turned on - help please | Excel Discussion (Misc queries) | |||
An FAQ that never seems to be answered: autofiltering with protection on... | Excel Worksheet Functions | |||
Protection issues | Excel Discussion (Misc queries) | |||
workbook protection | New Users to Excel | |||
protection on excel forms | Excel Worksheet Functions |