How to Protect the sheet, if few of the columns / rows are grouped

S

sudarsan

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display the merge function "url" of a picture? 0
How do i password protect my VB Code from users 2
Copying in sheet with protection with the use of a macro 5
auto-protect a sheet upon workbook close 4
paste if columns and rows are the same 2
hiding columns in grouped worksheets 2
Grouping on protected worksheets 4
Protect - Certain Rows / Columns 2

Top