Run an Event Worksheet_Change Macro

**gazzz_tha1** · 11-19-2010, 12:05 AM

Hi all, I'm trying to run a macro that will unhide row's once an option is selected in a validation dropdown list. I'm using the following 'borrowed' code:

Please Login or Register  to view this content.

My problem is, Excel 2010 doesn't seem to be recognising the Event and when I hit run, a dialogue box appears asking me to create a macro. I'm stumped...can anyone help please?

**gazzz_tha1** · 11-21-2010, 08:49 PM

Does nobody want to help with this?

**Paul** · 11-21-2010, 09:06 PM

Hi Gazzz, try:

Please Login or Register  to view this content.

**royUK** · 11-22-2010, 02:22 AM

Is the code in the sheet module?

**DonkeyOte** · 11-22-2010, 04:04 AM

FWIW, IMO:

Please Login or Register  to view this content.

is far from ideal

The effect of the Exit Sub in this context means as an end user if you remember to always update more than one cell simultaneously you can circumvent whatever code was put in place... it follows that this leaves the file (potentially) open to error pending actions being undertaken in the VBA

If >1 cell being altered then either (based on whether or not permitted):

Permitted: process all relevant cells within the Target

or

Not Permitted: Undo the action altogether* (toggling events as normal)

*Of course it's generally worth checking for blanks if they have no impact on the code rather than preventing mass clear.

**gazzz_tha1** · 11-22-2010, 11:37 PM

Hi Paul, royUK and DonkeyOte,

I've tried copying and pasting Paul's code into the sheet module as well as the workbook module and neither is working. As soon as I paste it and press run, it opens the Macro's dialogue box (see Word doc, Screen Dump). I'm trying to do what I thought would be the simplest of tasks by getting a macro to unhide lines depending on a selection in a dropdown box but its proving troublesome. (Excel sheet attached also)

**Paul** · 11-23-2010, 01:20 AM

The macro I gave you was an example. It was similar to your original code. The workbook you just provided is nothing like the sample code you provided.

The code I gave you needed a number of adjustments for it to work in your actual workbook. See below.

Please Login or Register  to view this content.

**gazzz_tha1** · 11-24-2010, 01:20 AM

Paul,

Thanks so much for your help, I've finally got my issue sorted and it all appears to be working properly now. I couldn't have done it without your help, thanks very much!

Gaz

**Paul** · 11-24-2010, 01:29 AM

Glad I could help, and that you have it working. If you wouldn't mind, please mark the thread as solved.

How to mark a thread Solved
Go to the first post
Click Edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save