Need help with worksheet_change script

P

programmernovice

Hello, I'm trying to write a script starting with


Private Sub Worksheet_Change(ByVal Target as Range)

which will save the worksheet when any cell in a certain range is
changed. However, after writing it, the script is not recognized in
the list of macros attached to the sheet. Somehow, it is not
considered a macro by Excel. Can anyone please tell me what is
happening and how I can correct it? Many thanks for all help.
 
D

Dave Peterson

Did you put the code in the worksheet module for that sheet?
Did you allow macros to run when you opened the workbook?
Did you save the file as a macro enabled workbook (*.xlsm) in xl2007+. (Ignore
this if you're using xl95-xl2003.)

What version of excel are you using?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with worksheet_change script 26
WIERD GLITCHED/ERROR IMAGE HELP APRECIATED! 1
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Unprotect Sheet for the duration of a script 7
Pass value variable to worksheet event 3
Worksheet_Change Woes 6
Highlight a cell after update in a specific range 2
If cancel list box don't enter FALSE in list 2

Top