Preventing inserts

[LadyReader]

I am instantiating Excel 2003 from vb.net and populating the spreadsheet from SQL. The workbook itself will be maintained even when the .Net program is inactive (so that the column headers are established and saved.)

Is it possible to prevent the users from inserting columns within a certain range?

If so, how is this best done?


Thanks for all help.

[teylyn]

Hi, when you protect the worksheet, you can select to allow or disallow insertion/deletion of columns. But I think this is a setting that applies for the whole sheet, so you cannot allow insertion in one area of the spreadsheet and disallow in another. It would be possible to create a macro that checks if the active column is in the allowed range, then unprotects the worksheet, inserts the column and protects the sheet again.

[LadyReader]

Thanks for answering the qustion and also warning me about the limitations of "Protect"!