How can I use VBA to turn my Excel application into a time-limited demonstration?

I have wrote a excell work book which he wants a demo

How can i give them it for a week to test out with some vba code in it to do this?


1.....I can put a time limit in to say for 1 day 1 week 1 month wich ever.

2.....vba code to stop them putting the clock back to access the work book

3.....The problem would come up if he wanted the workbook but no restriction in it IE time, also he has put in the
workbook a load of data in it.

3......He would want to keep the data that he put in

4......can a vba code be like this?
Your time is up for the demo , we have saved your data to a file but the workbook will not run now

5......He would send the workbook back to me to alter BUT how would I get in it to take out the time limit vba

6......I could then give it back to him

7......I have seen some where you can make it just run on one computer only henc not to send it anyone


SORRY for such a long ask


Thank you

OK - so firstly, have you reviewed the rules? When you do, you will see that your thread title is completely unacceptable.

Secondly, are you asking someone to build this entire demo for you? Or are you asking just if it's possible? Or something else?

The first of these would be way beyond the scope of a free forum, but you could use the Commercial Services section to pay someone to do it for you.

I shall update your thread title when I know what this request really is about.

Hi

Thank you for getting back to me


1....I did NOT know I had broken any of your rules.

2....My ask what I had done?

3....I did read about url and NOT asking to break or hack any code

4....I thought it was like any other forum where you can get help with code and user do write code
for the end user.

5.....So you are saying to sort this out I have to go to your site and Pay for some one to do this
very SMALL PIECE OF CODE Which IF it was a very long code to Wright and complicated then I
would not have any problems paying for.

6....to answer
"Secondly, are you asking someone to build this entire demo for you?"
If you look at what I put IE
"I have built/made this excel workbook"
So no it is built BUT do want a vba code to do what I ask.
7.....I presume that is why my first post did not get put on because some rule about
"thread title is completely unacceptable" why?


Wait waiting your reply

Kind Regards

===============================================

You have broken the rule about thread titles, which states:

1. Title must briefly summarize your request.

The word 'Demo' is not a summary of a request.

I will fix the title for you once I understand what you are asking for.

Yes, you can get help with your code - I suggest you attach the workbook so that your helpers can have a look and see if they are able to assist. Instructions are at the top of the page in the yellow banner.

Can you explain in one sentence what it is EXACTLY that you want help with? Your original post has 7 points and I cannot work out exactly what you want.

I have wrote a excell work book which he wants a demo

English may not be your first language, as this opening sentence does not make a lot of sense. Nor does much of the rest of the post. Sorry.

3....I did read about url and NOT asking to break or hack any code

I never suggested that you had!

"I will fix the title for you once I understand what you are asking for."
Thank you
=======================================================
"Yes, you can get help with your code - I suggest you attach the workbook so that your helpers can have a look and see if they are able to assist. Instructions are at the top of the page in the yellow banner."

It is NOT the workbook that I need help with.
I have no code to post, that is what I was asking for

===============================================
"English may not be your first language, as this opening sentence does not make a lot of sense. Nor does much of the rest of the post. Sorry.

Hmmm Sorry my english is not good for you I will redo for youit in plain english so you can understand it

I said
"I have wrote a excell work book which he wants a demo"

so you can understand

A person ask me to write a workbook for accounts which I did
he then ask if he could try it out
so far so good?
I said yes so called it a demo workbook
BUT I wanted to put code in this workbook to give him a trial for 1 month.
Okay do you get it now?
then the rest of my text is very clear and simple to follow I would have thought about the rest of the code etc
with out repeating it herr again
=================================================
"I never suggested that you had!"

You have broken the rule about thread titles


So to put it clear to what I want is the code to put in my workbook to do what I ask in my text.


Kind regards

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are still inexperienced here, I shall do it for you this ONCE: https://www.mrexcel.com/board/thread...-info.1240970/)

That's two rules broken so far today: pleae do re-read the forum rules, as I do not thnk you have understood them fully. Thanks.

In VBA: add code which will EXIT vba macro if your termination date is reached

To restrict access to VBA, password protect the VBA code. It will not be visible and hence cannot be changed/copied.

In terms of a thread title, maybe something like "How can I use VBA to protect my Excel application?" Or, alternatively, "How can I use VBA to turn my Excel application into a time-limited demonstration?" Probably the second one is more appropriate and relevant.

Whilst you have developed an application for your client, what you are asking for is an application in its own right.

You first need to force the user to enable macros. This is usually done with a Splash screen. The Workbook Open Event handler is used to make the Splash screen hidden and all the other sheets visible. This process is reversed when the workbook is saved and/or closed. Once that is in place, you can put a process in place to save the date and time the application is first opened. That allows you to check how many days/weeks/months the application has been used. And then you can take action to issue warnings and, eventually, save all the data in the sheets as values, save a copy of the static workbook as an .xlsx file, and kill the original macro enabled workbook.

Of course, the user might work around this process by starting a new copy of the application. That can be avoided by creating a file on the user's computer and checking for its existence.

And you'd need to protect the VBA project with a password.

All doable but not simple and it needs to work around your real application. You could spend significantly more time putting protection in place than you did on the actual application.

Finally, you need to bear in mind that Excel is not a secure environment. Many of the people on this forum could unpick any security you put in place (probably within minutes).

3....I did read about url and NOT asking to break or hack any code

I never suggested that you had!

You have broken the rule about thread titles

You have broken the rule about thread titles, NOT the rule about asking to break or hack code (which was never mentioned by me).

I will change the title, but your requirements still are not 100% clear to me. No matter: John and Trevor seem to get what you want.

In VBA: add code which will EXIT vba macro if your termination date is reached

That would be done in the workbook open event handler. You would also need to calculate and store the termination date.

To restrict access to VBA, password protect the VBA code. It will not be visible and hence cannot be changed/copied.

Probably not strictly true. Potentially difficult but not impossible.

Potentially difficult but not impossible.

Excel "hackers" aside, is there any other option ??.

To be fair, any protection you put in place will stop the majority of "typical" users. It will depend, however, on their ability and determination.

@JT: refer to post #11 (overlapped)

See: https://www.teachexcel.com/excel-tut...xcel_1390.html

Note that this is only one small part of the process described earlier.