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.


---
Message posted from http://www.ExcelForum.com/

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


---
Message posted from http://www.ExcelForum.com/

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?

"Gabriele C <" wrote:

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.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

dear dave,
i have abandoned the password-protected files cause i have encountered
lots of troubles in that way...here is what Microsoft says (too few)
http://support.microsoft.com/default...b;EN-US;214314
Thank you anyway!
gabriele


---
Message posted from http://www.ExcelForum.com/