Hi all,
Is it possible to use the HYPERLINK command that open up another Excel as READONLY?
Since I don't want the user to close that Excel with the 'Do you want to save....' everytime.
Thx.
Hi all,
Is it possible to use the HYPERLINK command that open up another Excel as READONLY?
Since I don't want the user to close that Excel with the 'Do you want to save....' everytime.
Thx.
Hi Dave,
But I'm trying to let user see it as HK
=HYPERLINK([ABC.xls]Sheet1!A142", "HK")
Any suggestion for this scenario?
Thx.
Hi Albert
Type the letters into any empty cell and color the text to Blue Now select the cell, hold down your Shift key and go to Edit>Copy picture. Now simply paste it over the needed cell, right click and select "Assign macro"
Wow! Problem SOLVED. Thx.
Can I assign this Macro to multiple buttons, while inside the code, is there a way I can tell which Button is calling?
Have a look at the example from this site
http://www.ozgrid.com/FreeDownloads/WhichControl.zip
Sorry couldnt get link to work but its on this site, should help with your query.
Oh, the link seems to have fixed itself up LOL , after I posted!
Don’t have an account yet? Register yourself now and be a part of our community!