Hello everybody
I am makeing a file which has a ‘status’ as a demo. Because it’s just a demo I want it to be opend max a certain number of times.
I saw somewhere a suggestion of a VBA statement called SaveSettings and GettSettings but I am stuck.
Can someone help me with a VBA code which will protect the file for being opened more that lets say five times ?
Saturn
Last edited by Saturn; 06-03-2013 at 09:51 AM.
What do you want to have the file do when it is opened more than fives times?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Then I want a message box telling the user that the file cant be opened because the file has reached its maximum usage.
The only way I can think of doing this is by embedding a counter in the file on a hidden sheet and doing it that way.
Any other suggestions ??
This could work, make a sheet named counter and hide it.
Please Login or Register to view this content.
Thanks a lot! but it seems not to work.
Please see the attachement.
Another thing is that this excel-file will contain many sheets, so its a need to prevent to open the entire workbook, not a specific sheet.
The code needs to go in the workbook module.
Try this.
This works! .. so thanks a lot JanaDave and I can use it
However it doesnt work exactly how I thought because the VBA is counting only if the user makes an update.
Is there any solution that VBA is counting up to the max number even if the user doesnt make any update / save the file without update ??
Try this, this will save the workbook without any updates made.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks