Open Cell Link(Bring to Front) with CommandButton on Userform

Hi all,

I've got a generated link which is placed into a sheet cell of my WB.
I need to also provide access to the file with a link on a userform through
a command button or a generated hyperlink (Label),if that's possible.

I am able to open with the following code using a command button.
However, thus far have not be able to figure out how to bring the openned excel spreadsheet forward / to the front while the userform is open.

Any help is greatly appreciated.

Please Login or Register  to view this content.

Thanks,

BDB

I think this is happening because userforms are by default modal. When you open the workbook it should be brought to the front, so you shouldn't need any code to bring it to the front. Go to the userform's properties; there is a property called ShowModal. If you set that to false, your workbook should still be accessible and the newly opened workbook will go to the top.

Yes, you can do that. I wouldn't use Excel as a variable name. Instead, I alway use xls. After you create the new Excel instance, just make it visible:

Please Login or Register  to view this content.

Then you will need to put xls. in front of any commands you want to run in the new instance of excel.