Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2009

    Question Unanswered: click to change colours

    Hi, we have created an index in a spreadsheet with a macro that moves the user to various other worksheets within the same workbook. The macro trigger text is located within the bounderies of an autoshape.

    What we are trying to do is have the autoshape change colour to grey when clicked in order to denote that the macro has been fired at least once during the current session.

    And just for bonus points, we would like the colours to reset when the user exits the worksheet

    If anyone can help with code for this it would be hugely appreciated.

    Last edited by Dalman71; 11-17-10 at 22:11.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts