Automatically create hyperlink in active cell when creating folders

Hello,

I borrowed and tweaked the code below to fit my needs. However, I would like to add one more feature.

When I hit my button to create a new folder, is it possible to have the code automatically create a hyperlink to the folder too??

Please Login or Register  to view this content.

I am sure this type of question has been asked already, but I cannot easily find exactly what I need and I am way too new with VBA to figure it out.

Thanks for the suggestions everyone.

Hi,

This is untested!

Please Login or Register  to view this content.

Hi,

Untested is good that it ran at all - what happens when you click on "Link" - and isn't it being placed beyond the used columns?

Try:

Please Login or Register  to view this content.

Still untested!

You're welcome!