"Avoid Inserting Rows / Columns"

G

Gokul77Jay

Hi,
Is there anybody to help me. How can i avoid inserting New Rows
Columns in an Excel worksheet ?.

Thanks in advance.
Goku
 
R

Rollin_Again

Your question makes no sense at all. What are you trying to do? What i
the problem you are having and what is your reason for not wanting t
insert rows or columns? Are you wanting to add some type of protectio
to the worksheet? Be detailed in your explanation and someone will tr
to help you.


Rolli
 
J

Jason Morin

One easy possibility is to put a value in cell IV65536.
Then hide column IV and row 65536. If you try to insert a
column or row, Excel will stop you.

HTH
Jason
Atlanta, GA
 

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

VBA - retrieve data on last create named range from previous inserted named range 0
Inserting Rows at Excel 2007 1
Inserting multiple rows 2
Copy sheet to different workbook sizing error message 2
Allow Insert Rows in a protected worksheet 2
Data in cell disappears, reappears by scrolling mouse over cell 3
insert rows in a worksheet that do not change adjoining rows 1
Insert Worksheet 2

Top