Ok heres the deal.
I have a macro button at the top of the page.
I want this button to be visible ONLY when I click on a cell is within a specified range.
I.E. - If I select a cell in the range A10:A20, I want the button to appear at the top of the page (or right next to the active cell if possible!). If I click on a cell outside of A10:A20, I want the button to dissappear.
I know the start of what the macro should be but I cant get anything to work
"Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)...................."
help!!!! thanks a million :wink:
I have a macro button at the top of the page.
I want this button to be visible ONLY when I click on a cell is within a specified range.
I.E. - If I select a cell in the range A10:A20, I want the button to appear at the top of the page (or right next to the active cell if possible!). If I click on a cell outside of A10:A20, I want the button to dissappear.
I know the start of what the macro should be but I cant get anything to work
"Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)...................."
help!!!! thanks a million :wink: