I appreciate your reply Catalin however what I need is to enable a password protect that does not allow users to delete all columns and the unhide column option is disabled.

Probably this behavior can be applied using VBA code. If you knew something about writing in VBA macro that would be great.

Thanks.

as i said, this can be done without a macro, you have attached a sample worksheet with columns G,H,i hidden, and all cells in sheet unlocked, so the users can enter data.

Just use the provided link with detailed instructions to do what you want.

and the sample

Attached Files

sample.xlsx (8.0 KB, 9 views)

thanks catalin for the inputs.

You're welcome