disabling cells

  • Thread starter Thread starter lak
  • Start date Start date
L

lak

Hi

I would like to know if there is any code in VBA by which i can disabl
cells in Excel once the work sheet is open.


Thank
 
Private Sub Workbook_Open(
ThisWorkbook.WorkSheets("name").Range("2:2").Hidden = Tru
End Sub
 
Hi
what do you mean with 'disable'?. You may unlock all other cells
('Format - Cells - Protection') and protect the worksheet to prevent
any entries in the remaining (locked) cells
 
Hi
thanx for the reply..however i dont understand how to unlock a cel
when the work sheet is protected b'cause the menu which
said(Format-Cell-unlock) is not enabled once the work sheet i
protected...Can u pls give me a step by step explanation.

Than
 
Hi x

Thanx for ur reply....in the codewhat does (2:2) stand for is it th
Row & column? can u pls tell me in detail.

Than
 
Hi
within your code do the following:
- unprotect the worksheet
- unlock the cell
- protect the worksheet again

Try recording a macro while doing this manually
 
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

Excel file compare (each sheet). Is there something already available?. 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
On-sheet activeX component disables copy/paste 6
Enter data in cell referenced in a cell 4
VBA set thick borders around non empty cells in range 0
Excel, assign cells in multiple worksheets from one sheet 1
Disable Clear DContents command in excel - vba code?? 3
VBA: Read picture filename 3

Back
Top