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 |
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 |
All times are GMT +1. The time now is 03:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com