How to trigger a macro on cell *selection*

Larry_1 · #3 12-24-2017, 09:06 AM

Oops. Sorry, NoSparks,

I was a very proficient Word user, but, having retired, I use it less and thus have fallen to being only reasonably proficient. In the mid 1980s I was a power user in Lotus 123, but I’ve not used it since. Although I can work in Excel somewhat, I’m a rank beginner in Excel VBA. In Word, you have to actually insert a table; I didn’t have to insert anything into Excel, it all looked like a “table,” and that was how I had been considering it. So that was an inaccurate description: I’ll have to read up on Excel tables.

What I have is a worksheet with data arranged in several columns (but I’ve not established it as a table – would this be easier if I did?), all the cells other than those in the document-number column are protected against selection or editing. The cells in that column permit selection but not editing. What does that do to your suggested solution?

Very respectfully,
an apologetic Larry

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Limit min and max number to a cell based on country selection	hussainshaikh1	Excel	1	02-02-2017 07:06 AM
How do I trigger a macro from a document?	brucemc777	Word VBA	4	01-25-2016 01:42 AM
Selection from cell with list contents autopopulates contents of another cell	markharper80	Excel	3	02-16-2015 04:18 PM
Hyperlink in cell to trigger pop up text box	Carpie	Excel Programming	0	08-13-2013 10:33 AM
ms office excel 2007 cell selection issues	pavamaklava	Excel	1	05-12-2010 10:47 PM