Hello,
I inherited a file I believe created in Excel 2010. I'm using 2016 now. It has a macro to create an Index sheet listing all worksheets and a hyperlink to each sheet. The macro also creates a hyperlink in A1 of each sheet to take the user to the Index sheet. I've used this macro...
Hi,
I need help to create a command button to remove hyperlinks from rows that have a 'date' on column E.
note:
the cells on column 'E' are linked to cell K4 on other files. if cell K4 on those files is blank the cells in column E will show as 1/0/00.
the logic I need is the following...
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.