how to programmatically fix row and column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'musing a client side to open an excel file (vbscript) how can i add
function to this script that fix the number of row and column. if a user
wants to add a new value outside the fix row or column it wont be allowed to.
thanks in advance.
 
Hi
one way:
- select all cells for which you want allow entries
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now protect your worksheet 'Tools - Protection'
 
In addition to Frank's suggestion of using locked cells and sheet
protection,
Look at the scrollarea property.
 
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

programmatically fix no. of rows and columns 1
convert columns to rows 6
Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel 2007: Return rownumber when text data on 3 columns match exa 1
How to locate a cell with dynamic column value 2
Mid column sum formulas with varied ranges to sum 17
Problem with a loop and column references 27

Back
Top