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

hiding columns in grouped worksheets 2
Allowing for Grouping and Ungrouping while Sheet is Protected 2
Protect - Certain Rows / Columns 2
Enable grouping in protected worksheet 2
Worksheet protection with grouped rows? 7
How do i password protect my VB Code from users 2
Group - Ungroup and Protect Sheet 2
I protect sheet - Macro will not run now 7

Top