Excel Checkbox interferes with Hyperlink

Question

I have a sheet that has a checkbox (linked to a cell on another sheet [gives True or False value in that cell], I also have a shape on the same sheet that has a hyperlink to another place in the Worksheet.

When I click on the Checkbox - and then click on the hyperlink - the hyperlink does not work...

If I click in a cell anywhere else on the sheet after clicking in the Checkbox then the Hyperlink will work if I click on it..

If I click on the hyperlink before clicking on the Checkbox it works...

I need the Hyperlink to work after the CheckBox is clicked.

Any ideas ?

Answer 1

With my testing I am not able to emulate the problem. Can you create and upload a simple workbook with a checkbox and hyperlink for testing purposes. Include VBA code (if any) that runs when the checkbox is clicked. The hyperlink must be accessible by me so ensure that I will be able to go to wherever the hyperlink points me to.

Guidelines to upload a workbook on OneDrive. (If you already use OneDrive and your process for saving to it is different then you can probably start at step 8 to get the link but please zip the file before uploading.)

1. Zip your workbooks. Do not just save an unzipped workbook to OneDrive because the workbooks open with On-Line Excel and the limited functionality with the On-Line version causes problems.
2. To Zip a file: In Windows Explorer Right click on the selected file and select Send to -> Compressed (zipped) folder). By holding the Ctrl key and left click once on each file, you can select multiple workbooks before right clicking over one of the selections to send to a compressed file and they will all be included into the one Zip file.
3. Do not use 3rd party compression applications because I cannot unzip them. I do not clog up my computer with 3rd party apps when there are perfectly good apps supplied with windows.
4. Go to this link.  https://onedrive.live.com
5. Use the same login Id and Password that you use for this forum.
6. Select Upload in the blue bar across the top and browse to the zipped folder to be uploaded.
7. Select Open (or just double click). (Be patient and give it time to display the file after initially seeing the popup indicating it is done.)
8. Right click the file on OneDrive and select Share.
9. Select "Get a Link" from the popup menu.
10. Click Copy the link and Paste into your reply on this forum.