click Code

C

cyote101

Active Member
Joined
Dec 11, 2004
Messages
315
Hello, I'm asking the same question, but in a diffent way.

first off i would like to thank all those who helped with the last one.

okay i have on a page a series of rows that when any cell in these rows are clicked i want the value in colum b to be sellected and pasted into D3.
the rows are 8,10,11,13,16,35 and 65.

Thanks, oh and by the way these cells are protected so even though the cells are not locked you can not select them
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
I'm not sure what you mean (or how you accomplished) the following:
these cells are protected so even though the cells are not locked you can not select them
Click to expand...
Typically, cells become protected from selection only when they are formatted as locked, and only when the sheet is protected.
If the cell can't be selected, do you want the value to be written to D3 when the user clicks the cell, even though the cell itself isn't being selected?
I'll can try to help solve this if I understand your question a bit better.
 
Upvote 0
I'm not sure what you mean (or how you accomplished) the following:
these cells are protected so even though the cells are not locked you can not select them
Click to expand...
Typically, cells become protected from selection only when they are formatted as locked, and only when the sheet is protected.
If the cell can't be selected, do you want the value to be written to D3 when the user clicks the cell, even though the cell itself isn't being selected?
I'll can try to help solve this if I understand your question a bit better.
Click to expand...

If the select check boxes are uncheck and the cells are not locked, you will not be able to select them when protected.

I am wondering if the poster is looking at a way of triggering the selection event and not allowing the cell that was clicked to trigger it from being selected.

I do this on one of my projects by selecting a cell that is hidden from view when certain cells are clicked while triggering a two second message in another cell:

Code: 
If Target.Address = "$G$15" Then

ThisWorkbook.Worksheets("Sheet1").Range("K2").Select

ThisWorkbook.Worksheets("Sheet1").Range("k12").Value = "This Field Can Not Be Modified!"

Application.Wait Now() + TimeValue("0:0:02")

ThisWorkbook.Worksheets("Sheet1").Range("k12").Value = StatusSavedMessage

End If

For a row:

If Target.Row = 18 Then

ThisWorkbook.Worksheets("Sheet1").Range("K2").Select

ThisWorkbook.Worksheets("Sheet1").Range("k12").Value = "This Field Can Not Be Modified!"

Application.Wait Now() + TimeValue("0:0:02")

ThisWorkbook.Worksheets("Sheet1").Range("k12").Value = StatusSavedMessage

End If

Perry
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
VBA & Combo Box (Form Control) Lock
Replies
3
Views
587
Jaafar Tribak
Jaafar Tribak
A
  • Question Question
Get “users” who edited cells
Replies
9
Views
239
aircarrier
A
D
  • Solved
VBA - Select a range of cells with keystrokes but don't want to see the cells
Replies
6
Views
288
Dan2k
D
N
  • Question Question
VBA - Intersect code being re-initiated
Replies
1
Views
178
Peter_SSs
Peter_SSs
S
  • Question Question
VBA code to determine InDesign Layout
Replies
6
Views
341
Akuini
Akuini

Forum statistics

Threads
1,222,731
Messages
6,167,891
Members
452,154
Latest member
lukmana_sam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top