a client wants me to write a spreadsheet with a limited number of
operations. when the number of operations is exhausted, a new code or
spreadsheet must be purchased.

is this or anything similar to it even possible?
--
Rolf Lindgren http://www.roffe.com/

Hi
not really possible. Esp. if the user disables macros.

--
Regards
Frank Kabel
Frankfurt, Germany


Rolf Marvin Bøe Lindgren wrote:
a client wants me to write a spreadsheet with a limited number of
operations. when the number of operations is exhausted, a new code
or
spreadsheet must be purchased.

is this or anything similar to it even possible?

Then they shouldn't be using Excel for there product. Tell them to get an App written from scratch

----- Rolf Marvin Bxe Lindgren wrote: ----

a client wants me to write a spreadsheet with a limited number o
operations. when the number of operations is exhausted, a new code o
spreadsheet must be purchased

is this or anything similar to it even possible
--
Rolf Lindgren http://www.roffe.com

"Frank Kabel" writes:

Hi
not really possible. Esp. if the user disables macros.

if the user disables macros the spreadsheet will not work at all.

--
Rolf Lindgren http://www.roffe.com/

Hi
but believe me: give me 1-5 minutes and I'll disable your VBA
protection with no problems. So there's no secure way to protect Excel
files + macros.
The most secure way is to create a COM addin of your code (e.g. get VB
6 and use this to create an add-in)

--
Regards
Frank Kabel
Frankfurt, Germany


Rolf Marvin Bøe Lindgren wrote:
"Frank Kabel" writes:

Hi
not really possible. Esp. if the user disables macros.

if the user disables macros the spreadsheet will not work at all.

"Frank Kabel" writes:

but believe me: give me 1-5 minutes and I'll disable your VBA
protection with no problems. So there's no secure way to protect Excel
files + macros.
The most secure way is to create a COM addin of your code (e.g. get VB
6 and use this to create an add-in)

is there a howto or something on how to do that? I'm relatively
unfamiliar with VB programming. I tend to pick up things fast though.

--
Rolf Lindgren http://www.roffe.com/

COM Add-ins are supported in xl2000 and later
Automation Add-ins are supported in xl2003 and later

http://support.microsoft.com/default...92&Product=xlw
INFO: Excel COM Add-ins and Automation Add-ins

http://support.microsoft.com/default...28&Product=xlw
HOWTO: Build an Office 2000 COM Add-In in Visual Basic

230689 SAMPLE: Comaddin.exe Office 2000 COM Add-In Written in Visual C++

http://support.microsoft.com/default...37&Product=xlw
HOWTO: Create a Visual Basic Automation Add-in for Excel Worksheet Functions

http://support.microsoft.com/support...dev/addins.asp

--
Regards,
Tom Ogilvy

"Rolf Marvin Bøe Lindgren" wrote in message
...
"Frank Kabel" writes:

but believe me: give me 1-5 minutes and I'll disable your VBA
protection with no problems. So there's no secure way to protect Excel
files + macros.
The most secure way is to create a COM addin of your code (e.g. get VB
6 and use this to create an add-in)

is there a howto or something on how to do that? I'm relatively
unfamiliar with VB programming. I tend to pick up things fast though.

--
Rolf Lindgren
http://www.roffe.com/