limit the number of operations of worksheet

  • Thread starter Rolf Marvin Bøe Lindgren
  • Start date
R

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?
 
W

why?

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
 
R

Rolf Marvin Bøe Lindgren

Frank Kabel said:
Hi
not really possible. Esp. if the user disables macros.
Click to expand...

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

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)
 
R

Rolf Marvin Bøe Lindgren

Frank Kabel said:
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)
Click to expand...

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.
 
T

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
 
Top