limit the number of operations of worksheet

[Rolf Marvin Bøe Lindgren]

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?

 

[Frank Kabel]

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

 

[Guest]

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 Marvin Bøe Lindgren]

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

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

 

[Frank Kabel]

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)

 

[Rolf Marvin Bøe Lindgren]

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.

 

[Tom Ogilvy]

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

http://support.microsoft.com/default.aspx?scid=kb;en-us;291392&Product=xlw
INFO: Excel COM Add-ins and Automation Add-ins

http://support.microsoft.com/default.aspx?scid=kb;en-us;238228&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.aspx?scid=kb;en-us;285337&Product=xlw
HOWTO: Create a Visual Basic Automation Add-in for Excel Worksheet Functions

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