How to block cells with VBA

**jose_luis_fdez_diaz** · 04-09-2010, 06:36 AM

Hi,

How can I block all cells except the first column with VBA in Excel 2003?

Thanks in advance,
Jose Luis

**rwgrietveld** · 04-09-2010, 06:53 AM

This code will LOCK all cells in the active worksheet, Unlock the ones in column A. Password is set to "password"

Please Login or Register  to view this content.

**jose_luis_fdez_diaz** · 04-09-2010, 08:05 AM

Thanks for your help.

When I try to change color in a unblocked cell:

Range("A1:A1").Interior.Color = RGB(200, 160, 35)

the 1004 error is returned. Why?

Regards,
Jose Luis

**rwgrietveld** · 04-09-2010, 10:01 AM

Change this part:

Please Login or Register  to view this content.

**jose_luis_fdez_diaz** · 04-21-2010, 04:06 PM

Now, I can't erase cells in unblocked cell· How I can give all the "permisions" to the unblocked cells?

Regards,
Jose Luis

How to block cells with VBA

LinkBack

Thread Tools

Rate This Thread

Display

How to block cells with VBA

Re: How to block cells with VBA

Re: How to block cells with VBA

Re: How to block cells with VBA

Re: How to block cells with VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions