+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting on shape assigned macro

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    1

    Conditional formatting on shape assigned macro

    Hi,

    I was wondering if it was possible to place a condition on a shape (which has a macro assigned to it) to be hidden or visable depending on the contents of 1 or 2 cells?

    Essential if these 2 cells have been filled a the macro will appear. Otherwise it will not be visable.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Conditional formatting on shape assigned macro

    Try:-
    Nb:- Change cells & shape to suit:-
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Use a button to control a macro that inserts an image into a shape or resets the shape
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 04:41 PM
  2. Replies: 0
    Last Post: 11-30-2012, 01:29 PM
  3. Conditional formatting needed for shape colour - is programming needed?
    By Farmboyuk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 07:27 AM
  4. Macro for formatting fonts and cell colours - not Conditional Formatting
    By Kayaness in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-07-2011, 03:46 AM
  5. shape (with macro assigned) flashes upon click
    By grime in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2006, 01:40 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1