stockman256
New Member
- Joined
- Jul 25, 2010
- Messages
- 8
I have a spreadsheet that I’m going to sell on either a monthly or yearly basis (I’m selling both, the user has option to pick). I know I can put in an expiration code in a macro and run that macro upon opening the document and not allow access if the current date is after the date in the macro.
Two questions:
1. Is there a better way to control access for a limited time?
2. If this is the best way, is there a way I can update the date upon renewal with a separate macro or do I have to send a new spreadsheet after renewal?
Two questions:
1. Is there a better way to control access for a limited time?
2. If this is the best way, is there a way I can update the date upon renewal with a separate macro or do I have to send a new spreadsheet after renewal?