LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default Is it possible to require that a KEY NUMBER be imputed in a workbook 1 before workbook 2 can be opened?

I am trying to protect my Excel application from being using by others
who obtain an illegal copy. What I am hoping to do is set up a main
workbook. I call this HOME BASE. This has hyperlinks to open the
other workbooks. You would be required to enter your assigned KEY
number into a field in HOME BASE. All the other workbooks would have
that KEY number hidden in a field in the first worksheet. When you
click on a hyperlink open another workbook, that workbook would look
to HOME BASE to see if (1) HOME BASE is open and (2) if the KEY NUMBER
matches with the one entered IN HOMEBASE. I don't know VBA so if
there is a solution for this please write complete instructions on how
to code and where to place it. If you have other suggestions please
let me know. Responses or suggestions to my email:



Sincerely,



Marcello
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
open workbook b when workbook a opened [email protected] uk Excel Discussion (Misc queries) 5 July 23rd 08 01:02 AM
Unhide Row when workbook is opened Wanna Learn Excel Discussion (Misc queries) 8 October 19th 07 04:55 PM
Limiting Number of Times a Workbook can be Opened Dan R Excel Worksheet Functions 1 February 13th 07 03:28 PM
activate opened workbook via VBA Noemi Excel Discussion (Misc queries) 1 May 3rd 06 01:21 PM
Run a macro when a workbook is opened Mervyn Thomas[_3_] Excel Programming 0 July 25th 03 11:18 AM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"