hyperlink to pw-protected files

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.
 
G

Gabriele C

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...
 
D

Dave Peterson

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?
 
Top