hyperlink to pw-protected files

  • Thread starter Thread starter Gabriele C
  • Start date Start date
G

Gabriele C

Hi mates...
My question:
I have many hyperlinks in a sheet, that points to password-protected
worksheets.
Is it possible to make the program enter the password by code?
Hope someone can help
Thank you.
 
I've searched a lot with google,but it seems to be impossible...
Is it possible,instead,to catch link's path once user clicks on
it,prevent excel opening the file,put into a variable,then use
workbook.open?
I'm a newbie with VB,if someone can help me...PLEASE!
Thank you...
 
I don't know a way.

Maybe you could simulate a hyperlink with a rectangle floating over the cell.
When the user clicks on that cell (actually the cell), then the macro associated
with the rectangle would open the workbook by supplying the password.

But where would the password come from?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code for Allow Insert Hyperlink 2
Locked Cells and Hyperlinks 1
Confirming password 6
Can protect worksheet then workbook but not Protect and Share in code 5
Unprotect entire sheet 1
Sheet protection complications 4
Controlling worksheet protection via VBA 0
Marco to protect / unprotect worksheet 2

Back
Top