Lock Button that Locks Specific Cells

Hello-

This should be very simple, but I've run into an error:

What's trying to be accomplished:
- When user clicks on a button, VBA selects and locks a cell

What's been done:
- Very simple VBA code attached to a button:

Please Login or Register  to view this content.

Sheet/Book conditions:
- The entire sheet is locked and protected with the exception of the cell (F6) and the button
- When protecting, 'select unlocked sells' and 'format cells' are checked

Current error I'm getting:
Unable to set the Locked property of the range class

This is very basic, and it has me stumped. Thoughts?

Thx!

mushman1,

Welcome to the forum. Please read forum rules before posting again. I've wrapped your code for you.

The code won't run on a protect sheet. See link for workaround

http://www.ozgrid.com/VBA/excel-macr...cted-sheet.htm

Also you don't need to select

Please Login or Register  to view this content.

VBA Noob

You're posting in a thread from 2008.
You need to start your own thread.