Posted to microsoft.public.excel.misc

daidipya

Posts: n/a

assign macro to a lise

i have one macro as follows

Sub HideRows()
Dim Rng As Range
Set Rng = Sheets("Sheet1").Range("B10")
If Rng.Value = "YES" Then
Rows("11:50").EntireRow.Hidden = False
Range("B11").Select
ElseIf Rng.Value = "NO" Then
Rows("11:50").EntireRow.Hidden = True
Range("B51").Select
End If
End Sub

now i want that whenever i change in the values in cell B10 the said
macro should run. Please help me out

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
how to create a command button, then assign macro to it in excel	kshaheen	Excel Discussion (Misc queries)	3	June 24th 08 01:03 PM
Compiling macro based on cell values	simonsmith	Excel Discussion (Misc queries)	1	May 16th 06 08:31 PM
assign macro	PH NEWS	Excel Worksheet Functions	2	February 28th 06 02:17 PM
Macro Help In Excel	welshlad	Excel Discussion (Misc queries)	14	October 26th 05 02:34 PM
Highlight Range - wrong macro, please edit.	Danny	Excel Worksheet Functions	8	October 19th 05 11:11 PM

All times are GMT +1. The time now is 02:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us