Posted to microsoft.public.excel.programming

RAP

external usenet poster

Posts: 49

Workbook_SheetChange not working

It was working, but I changed a cell entry to a formula and now it won't run.
The two macros I call in the Sheetchange macro run fine when run manually.
Here's the code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Source As Range)
VRange = Range("B3:B7")
Call CheckCellColor
Call RoundOff
End Sub

What am I overlooking? Thanks for any help. - Randy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Workbook_SheetChange	Matt B[_3_]	Excel Programming	3	April 25th 05 01:40 PM
Worksheet_Change and Workbook_SheetChange not firing	David Jenkins[_2_]	Excel Programming	4	September 2nd 04 08:02 PM
Workbook_sheetChange event	J S	Excel Programming	0	August 9th 04 07:16 PM
workbook_sheetchange	JulieD	Excel Programming	1	June 14th 04 04:32 AM
Workbook_SheetChange will not fire	Robert Willard	Excel Programming	1	September 10th 03 07:52 PM

All times are GMT +1. The time now is 11:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us