View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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