Demo code info

build56

New Member
Joined
Jul 11, 2023
Messages
1
Office Version
  1. 2007
Platform
  1. Windows
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
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Your ideas might work ONLY if the end user has no knowledge how to access the code and make changes. Thee only method I am aware of that pretty much
guarantees total security is to use a 3rd party software that obfuscates the project code which prevents the end user from understanding the project code.
 
Upvote 0
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Demo
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0

Forum statistics

Threads
1,215,170
Messages
6,123,422
Members
449,099
Latest member
COOT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top