"Avoid Inserting Rows / Columns"

  • Thread starter Thread starter Gokul77Jay
  • Start date Start date
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
 
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
 
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
 
Hi
one way is to protect the worksheet (goto 'Tools - Protection')
 
You must log in or register to reply here.

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
Lookup Column Headings and Sum the Rows 3
Inserting Rows at Excel 2007 1
Excel Help to copy information from one row at a time to another sheet 1
how do i paste rows/columns avoiding hidden rows/columns 1
Insert Row (Event Classification) 3
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Insert Row formatting 1

Back
Top