"Limited Use Question?"

  • Thread starter Thread starter DEG
  • Start date Start date
D

DEG

How do you (or can you) limit the use of a macro to a certain number of Uses?
Uses being opening the WB and allowing macros.... macro could run any number
of times once the WB was opened. Some kind of counter installed so the OP
could not change it.... Hope I have described what I'm after here.... TIA

Don
 
Thanks for the response Roy....but I didn't want to close the WB, just make
the macros inactive.......
 
There would be a data sheet that they would still be able to read, enter and
print from.....the macro's just automate some frequently used functions......
 
Roy,

Can't thank you enough. I've now had a chance to try out a couple of the
solutions you laid out and they all work well. I chosen to use a cell in a
hidden sheet and use vbveryhidden to hide same....seems to be a little more
secure. The named range solution works well but IMO would be too easy for an
OP to overcome. If there is a way, other than a macro command, to "unhide" a
veryhidden sheet it eludes me.

Anyway, thanks again for your help and for staying with me on this...have a
great day....

Don
 
Back
Top