Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect sheet but be able to merge cells
Can anyone let me know if it is possible to protect a sheet, but still be
able to merge certain cells. I tried to allow users the access to 'format rows' and 'format cells', but it wont allow me to merge cells. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect sheet but be able to merge cells
First, I do my best to avoid merged cells. They cause trouble with copy|paste,
sorting, filtering, and lots of other stuff. Maybe you can provide a macro that unprotects the sheet, merges the cells, and then reprotects the sheet. Protect Sheet but be able to merge cells wrote: Can anyone let me know if it is possible to protect a sheet, but still be able to merge certain cells. I tried to allow users the access to 'format rows' and 'format cells', but it wont allow me to merge cells. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to lock 5 cells but not protect entire sheet | Excel Discussion (Misc queries) | |||
Protect Sheet: clicking in cells removes all previous text | Excel Discussion (Misc queries) | |||
Protect Sheet: clicking in cells removes all previous text | Excel Discussion (Misc queries) | |||
How do I protect individual cells in Excel and not whole sheet? | Excel Discussion (Misc queries) | |||
Locked cells with Protect Sheet. | Excel Discussion (Misc queries) |