Help with cmd btn that allows a user to select pre-created empty cmd btn in column & save a hyperlink to file

calebeenie

Board Regular
Joined
Apr 6, 2014
Messages
52
Hello all,

Beginner to Intermediate VBA here.

I am trying to create VBA code to:

1) upon clicking master cmd btn 1 (always in same cell on worksheet, named "Save File")
2) pop up window asking which empty cmd btn in col A would I like to save hyperlink to
3) then another pop up window to browse through machine and select file
4) save the hyperlink to the chosen cmd btn in col A
5) then every time I click on chosen cmd btn in col A it opens file to print/view

I have working vba to open "browse window" / select a file - but the combination of all above is just a tad outside of my vba experience.

Any thoughts? Much thanks in advance.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,203,388
Messages
6,055,129
Members
444,763
Latest member
Jaapaap

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top