Random question / passwords in excel

[KevinThomas]

Hi All,
I want to set a question upon opening my spreadsheet which will only open if the correct answer/ password is typed.

I’d need to store the questions, passwords/ answers somewhere for VB to look up I guess??

This is a bit above my station.

So I need help with the actual storing the questions/ answers (For example I will use)

Capital of England – London
Capital of France – Paris
Capital of Italy – Rome

Etc etc

And then I need coding which will open one of the random questions, which will only grant access to the spreadsheet if the correct answer is typed.

Any help much appreciated

[mudraker]

The method you have described is not very secure - If macros are disabled the workbook can still be opened.

You can have a set password that has to be entered before the book is opened

If you insist on using VBA & having the user anser a question then you would probally need to look at code to hide your sheets that would only be made visible if macros were enabled

[KevinThomas]

Hi thanks for the comment. By fixing a password before the sheets open – this would have to be one set password am I right?

Is there any way to vary what the password is (with a set range of course)?

[broro183]

hi Kevin,

To add to Mudraker's comments, Excel is not known or touted as a "secure" environment so it is not recommended to rely on the security for highly confidential information etc. Here is a link which outlines the forms of inbuilt Protection provided by Excel: http://spreadsheetpage.com/index.php...otection_faq1/

The below section may be of the most interest to you...
http://spreadsheetpage.com/index.php...ction_faq1/#P2

hth
Rob

[modytrane]

Here's a sample excel workbook that forces users to enable macros.
You can then have your random question prompt in the workbook_open event.
I received this code on this forum from one of the gurus and modified it to suit my needs.
Hope this gets you going in the right direction.
modytrane.

[martindwilson]

modytrane dont know what thats supposed to do but all it does in 97 is open a work book with no visible tabs!
i can the use alt f11 to edit delete all the code!

[modytrane]

martin,
try it now.
the vba is password protected. that was the intent when i sent it out with my previous message. i first wanted kevin to work out his other code to enter a list of questons and answers.
if you don't enable the macros, in excel 2003 it opens one sheet with a message that tells the user that this program doesn't work unless you enable the macros.
if you enable the macros, it will open one blank worksheet that you can work with.
modytrane.

[martindwilson]

ok thats better
cant view vba. but only get blank workbook with no tabs, no message to enable.

[modytrane]

martin,
Here's the same workbook.
Can't view the VBA.
When you open with macros enabled, you get the tabs, three worksheets.
You can add more and create whatever sheets you want.

In the previous version you could have added worksheets if you wanted to.
You could also got ot tools\options and make the sheets visible.

I didn't understand your comment "no message to enable".

When you tried to open without enabling macros, did you get a message sheet telling you to please close the workbook and re-open with macros enabled?

modytrane

[martindwilson]

thats better cant view vba and now i see message(i forgot my settings enabled macros any way) if i disable macro.