Need help with worksheet_change script
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. |
Need help with worksheet_change script
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? On 06/14/2011 13:50, programmernovice wrote: 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. -- Dave Peterson |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com