Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
with the following procedure entered into the sheet code of "Sheet1" the
method fails why? Private Sub Worksheet_Change(ByVal Target As Excel.Range) Sheets("Sheet2").Select Range("A1").Select End Sub I can enter the above code into a normal macro in a normal module then call that sub fro the sheet code. but that seems daft, why doesn't it work directly? stuart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CODE PROBLEM | Excel Discussion (Misc queries) | |||
VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Problem pasting a row from a hidden sheet to the first free row on another visible sheet | Excel Programming | |||
unprotect sheet in code and make sheet visible | Excel Programming |