Finance 3.0 - Social Network for Finance
Smart financial thinking
Excel Model (Need Help)
Hi All,
I need to develop a time based model that i want to be expired after a certain amount of time. Kind of like a trial version. After a certain date the excel workbook will not run and the spreadsheet will be blank. How can I formulate it or how to build a macro that will make this happen? Your help will be GREATLY appreciated!
Regards,
Shakeel
I need to develop a time based model that i want to be expired after a certain amount of time. Kind of like a trial version. After a certain date the excel workbook will not run and the spreadsheet will be blank. How can I formulate it or how to build a macro that will make this happen? Your help will be GREATLY appreciated!
Regards,
Shakeel
Replies to This Discussion
-
Permalink Reply by Sachidanand (Sacha) Singh on -
Supose yoiu do not wish the model to run after 20 Feb 2010. This is 40229 in Excel date series. Enter Today() in any cell, say in A1. Mkae the key operations subject to A1<40229, from 20th Feb onwards the model will not run.
Sign in
Badge
Continuing Education
 |
Accounting |
 |
Banking Regulations |
 |
Certification Training |
 |
Commercial Bank Management |
 |
Corporate Finance & Valuation |
 |
Treasury Management |
 |
Credit Risk Management |
 |
Financial Derivatives |
 |
Financial Institution Management |
 |
Financial Markets |
 |
Financial Modeling |
 |
Financial Planning |
 |
Market Risk Management |
 |
Operational Risk Management |
 |
Operations & Compliance |
 |
Quantitative Analysis |
 |
Strategic Financial Management |
Newsletter
Linkedin
RSS
Facebook
Widgets
Twitter© 2010 Created by Finance 3.0
