Restrict column adding and widening

**mattsgr1** · 02-28-2007, 08:06 AM

Is there a way I can stop a user adding or widening columns without locking the spreadsheet??

I've seem other spreadsheets with limited number of columns, how is this put in place??

Thanks

**Carim** · 02-28-2007, 08:09 AM

Hi,

Two separate questions ...
1. Protect worksheet
2. Hide unwanted columns ...

**mattsgr1** · 02-28-2007, 08:12 AM

Sorry:

1. I didnt want to protect the worksheet.
2. Hiding the columns won't stop a persistent user unhiding them.

Any other suggestions?

**mattsgr1** · 03-07-2007, 06:26 AM

Originally Posted by mattsgr1

Sorry:

1. I didnt want to protect the worksheet.
2. Hiding the columns won't stop a persistent user unhiding them.

Any other suggestions?

Can anybody please help me?

**Carim** · 03-07-2007, 06:40 AM

Protecting the worksheet (with a password) is the simple quick and easy solution ...

If you are after a lot more sophistication (and difficulty), you can get into manipulating Excel's menu in order to prevent user from getting to the various commands related to your objective ...

**VBA Noob** · 03-07-2007, 06:44 AM

Hi,

If you hide the unused columns e.g say Col H to IV then go

Tools > options > View tab > untick rows and column headers most general users wouldn't know what you have done....

VBA Noob