| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Protect the sheet, if few of the columns / rows are grouped
Hi,
I have a worksheet where i grouped couple of columns.This grouping is working fine.If i protect the respective sheet, i am unable to ungroup those columns.I don't want others to overwrite my code in my worksheet.So i want to protect the sheet any how. Please suggest me how can I go about it. Regards, sudarsan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Protect the sheet, if few of the columns / rows are grouped
How do you "group" columns?
Aside from that, lock your VBA Project from viewing with a password so users cannot access your sheet code. Gord Dibben MS Excel MVP On Thu, 16 Oct 2008 09:34:05 -0700, sudarsan wrote: Hi, I have a worksheet where i grouped couple of columns.This grouping is working fine.If i protect the respective sheet, i am unable to ungroup those columns.I don't want others to overwrite my code in my worksheet.So i want to protect the sheet any how. Please suggest me how can I go about it. Regards, sudarsan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I protect a sheet so the rows/columns can't be deleted? | Excel Worksheet Functions | |||
| Collapse grouped rows and columns on opening workbook | Excel Discussion (Misc queries) | |||
| Grouped columns & rows | Excel Worksheet Functions | |||
| Grouped Columns/Rows | Excel Worksheet Functions | |||
| working with grouped rows and columns | Excel Programming | |||
Linear Mode
