HELP PLEASE
Board Regular
- Joined
- Jan 8, 2005
- Messages
- 156
Please help with code...
Problem 1:
If A1="Excel" run Macro1 but if A1 equals anything other than "Excel" run Macro2.
Problem 2:
Run Macro3 the next 3 times the spreadsheet is opened. The 4th time it is opened, Macro3 should not run.
Problem 3:
Macro4 is called to run on the opening of the spreadsheet (it is called in the ThisWorkbook folder). If the calander year equals 2007 I need to prevent Macro4 from running when the document is opened.
Thanks so much!
Problem 1:
If A1="Excel" run Macro1 but if A1 equals anything other than "Excel" run Macro2.
Problem 2:
Run Macro3 the next 3 times the spreadsheet is opened. The 4th time it is opened, Macro3 should not run.
Problem 3:
Macro4 is called to run on the opening of the spreadsheet (it is called in the ThisWorkbook folder). If the calander year equals 2007 I need to prevent Macro4 from running when the document is opened.
Thanks so much!