Opening up a new data base using a macro or navigation button

[go2review.com]

I have a simple macro that down loads info into a spread sheet this information is confidential, so i need some sort of password that protects this down load being accessed by everyone, the button is on the opening page. Or the navigation button open up another data base then i can protect that with a password.

no that brill at programming so please try and take this into account

thanks

 

[DCrake]

From what I gather the data is in an Access table that is transfered to an Excel spreadheet via a button on a form. This is automated using a macro.

What I would be tempted to do is to create an interveening form that asks the user for a password. If successful it then opens up the form that does the download.


Or only make the button enabled if a certain user(s) are logged in.

David

 

[go2review.com]

sound good

the navigation button that only a certain user sounds the best idea, how do i do this