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: 143
Default Bypass an

When I created the latest versions of my Excel project, I included this
code:


Private Sub Workbook_Open()

CopyrightAnnouncement

End Sub


Sub CopyrightAnnouncement()


Dim Config As Integer
Dim Ans As Integer

Config = vbYesNo + vbQuestion + vbDefaultButton2

Ans = MsgBox("This program is copyrigted and is currently only
licensed on loan to and for the exclusive use of Sherri Allen. All
rights are retained by the owner and deleveloper, Ken Loomis. Are you
Sherri Allen?", Config)
If Ans < vbYes Then
ActiveWindow.Close
End If

End Sub

I though that would help me be sure that only one person used this file.

But now that I need to open and fix all the files that this project created,
it seems to be a problem.

Is there a way to open those files without having to make the user answer
that dialog box?

Thanks,
Ken







 
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
Bypass worksheet_change event Dr.Schwartz Excel Programming 3 May 27th 05 02:20 PM
Bypass Replace File Jon M.[_2_] Excel Programming 1 August 20th 04 09:38 PM
Bypass Textbox Validation Myrna Rodriguez Excel Programming 4 July 9th 04 11:36 PM
Can you bypass excel generated pop ups. Wandering Mage Excel Programming 2 July 8th 04 11:18 PM
Bypass macros in Read only Lawlera Excel Programming 2 November 27th 03 10:46 AM


All times are GMT +1. The time now is 04:01 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"