Discussion Locked

Agree to Disclaimer B4U can run xls file

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

All users will have Excel 97. Spreadsheets will be distributed to these partner organisations via website access (as links to .xls files not html copies) or on CD-Rom.

Objective: everytime they access one of these spreadsheets they have to clicksomething to say they agree to the displayed terms of use/copyright, etc..

Solution? Could I password protect the spreadsheets and customise the password prompt text to read as the disclaimer, enter AGREE below as the password if you agree to be bound by these terms? Obviously I can only customise the files not their copy of Excel the program. Don't know much about macros (they may be locked down to not run them). Don't know anything about VB programming though we are a Select partner so have all the Microsoft applications available to us. Cookies won't do it for browsing to individual files on the CD-rom, I would guess?

Any bright sparks out there will possible solutions please?

Many Thanks

John Murphy

7 replies

by shanghai sam

You can do this with VBA. Use the Auto_Open macro to display the disclamer. You can preset the VISIBLE property of the worksheets to xlVeryHidden. You can also rehide the sheets upon closing. You could also password protect the sheets using VBA if you wanted.

Option Explicit
Sub Auto_Open()
Dim sh As Worksheet
Dim sDisclamer As String
sDisclamer = "Do you ACCEPT the disclamer?"
If MsgBox(sDisclamer, vbYesNo, "Do you accept responsibility?") = vbYes Then
For Each sh In Sheets
sh.Visible = True
Next sh
Else
ThisWorkbook.Close SaveChanges:=True
Application.Quit
End If
End Sub
Sub Auto_Close()
Dim sh As Worksheet
Sheets("Sheet1").Select
For Each sh In Sheets
If sh.Name <> "Sheet1" Then
sh.Visible = xlVeryHidden
End If
Next sh
ThisWorkbook.Close SaveChanges:=True
End Sub

Create a workbook with 3 sheets. One sheet will always have to remain visible. Go to the Visual Basic Editor and add a module and pastethis code. This should get you headed in the right direction.

by johnm

Thats great, thanks. I have had trouble replying via these forms, as I wanted to ask how to paragraph the disclaimer text within the VB script (what syntax to start a new line/paragraph). Also, one sheet has to open - can I make sheet1 the data, andopen sheet2 instead with the copyright/disclaimer information on it? Thanks, John.
johnm@essex.tec.org.uk

by tclere

Hey! That's my post.

I am not sure what happened. I was logged on, but it seems that my post was recorded under a User Deleted???

by lo

Hi - Not a solution but a design question.
Why would you want to impose the need to 'accept' an agreement every time someone performed a function that was kind of what they were at work for?

If I am understanding, each time they open a file they have to agree to what they have already agreed to on a previous session or file.

Such agreements are usually done as part of an install and only once (per install). The agreement can be worded such that any access to any file distributed, provided or accessed to which you own rights can be covered. The agreement is mostly a legal protection, which , should you end up in court, gives you a basis to prove breech of contract and such.
Why not have them agree get a mail or file or some such (or a registeration to your site).
If you use Excel, Word, Powerpoint, Access, etc.) would you want to have to agree to abide to something (same stuff you did yesterday) every time you opened a file?

Just a thought, lo

This discussion is closed to new replies.