That problem is now solved.Macros execute only if I click within E7 to I29. Thank you for that.
Can you help me with this last request. You know this line
If ThisCell.Row >= 7 And ThisCell.Row <= 29 Then Run "copy_master_to_hypelink_all_sites"
Can we make here a conditional rule to choose between 4 codes instead launching this "copy_master_to_hypelink_all_sites"
The 4 codes are following
Application.Run "copy_master_to_hypelink_all_sites"
Application.Run "copy_master_to_hypelink_Basildon"
Application.Run "copy_master_to_hypelink_Burnley"
Application.Run "copy_master_to_hypelink_Ilkeston"
I have x4 OptionButtons on the sheet.
OptionButton1
OptionButton2
OptionButton3
OptionButton4
Not to be confused with tickboxes. By OptionButtons I mean the ones that you can click and little dot will appear inside. The ones when only 1 can be clicked i.e. as soon as you click any other box the little dot will move to that clicked box.
Now I would like to add this feature. When clicked to any cell listed in the code it would first check which OptionBox is currently ticked to determine which code to launch.
OptionButton1 - Application.Run "copy_master_to_hypelink_all_sites"
OptionButton2 - Application.Run "copy_master_to_hypelink_Basildon"
OptionButton3 - Application.Run "copy_master_to_hypelink_Burnley"
OptionButton4 - Application.Run "copy_master_to_hypelink_Ilkeston"
then it would carry on launching macros as per addressed target
Example:
Lets say OptionButton2 is currently ticked. If I would now click cell E8
it would first see that OptionButton2 is ticked and it runs Application.Run "copy_master_to_hypelink_Basildon"
then as per target code it would carry on with Application.Run "hyperlink_backlog_DNB_monday"
Would you be so kind to assist me with this?
Cheers
Rain
Bookmarks