Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If statement in Auto_Open
When an Excel Workbook opens, if cell A1 in Sheet1 contains nothing I
want Excel to run Macro1. If cell A1 in Sheet1 contains the text "Hello", I want Excel to do nothing. I've tried this: If (Sheet1)A:1 = "Hello" Then Range("A1").Select Else Macro1 End If but VB gives me the red pen for the first two lines. Any ideas? Kind regards Ian M |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If statement in Auto_Open
If Sheets("Sheet1").Range("A1") = "Hello" The Range("A1").Selec Els Macro End I ----- Ian M wrote: ---- When an Excel Workbook opens, if cell A1 in Sheet1 contains nothing want Excel to run Macro1 If cell A1 in Sheet1 contains the text "Hello", I want Excel to d nothing I've tried this If (Sheet1)A:1 = "Hello The Range("A1").Selec Els Macro End I but VB gives me the red pen for the first two lines Any ideas Kind regard Ian |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If statement in Auto_Open
Chris
It works perfectly! Thanks again for your help. Kind regards Ian M *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTO_OPEN | Excel Discussion (Misc queries) | |||
Auto_open and more.... | New Users to Excel | |||
Auto_open and more.... | New Users to Excel | |||
Auto_open | Excel Discussion (Misc queries) | |||
Beyond AUTO_OPEN | Excel Programming |