AutoShapes

Aug 3, 2006

Got a workbook with two sheets. Under Sheet1: I create two Autoshape Bevel's. One is to display the two pictures, one is to hide the two pictures. If I hit a Bevel 1 or Bevel 2, I want the code to be written into the Workbook so when I open it up again it will remember what settings I had.

Under Sheet2: In the VBA code I have. I want to put a Two IF statments in here to make the logical decisions for me. I have tried it but they can't recognize the AutoShapes. I was using "ActiveSheet.AutoShape("Autoshape##")_Click", but it was not picking up a variable.

Private Sub Worksheet_Activate()
ActiveSheet.Shapes("Picture 32").Visible = True
ActiveSheet.Shapes("Picture 33").Visible = True
ActiveSheet.Shapes("Picture 32").Visible = False
ActiveSheet.Shapes("Picture 33").Visible = False
End Sub

I link the two bevel's on Sheet1 to run the Macro on Sheet2!Worksheet_Activate. How do I find the name of the Bevel's? Can I use If Statements, so make decisions on which Bevel was pressed, and retain the settings for the next time I open the Workbook ?

View 5 Replies


ADVERTISEMENT

Autoshapes In Charts

Feb 19, 2007

I have a chart which has Autoshapes linked to other cells in the spreadsheet above each bar on the chart. Is there any way of making them dynamic, so that if the value of the bar changes, the Autoshape will move up or down with that bar?

View 4 Replies View Related

Colouring Autoshapes Using Macro

Jan 27, 2009

Just trying to work out the best way to be able to determine autoshape colours using cell values. For example I have 12 shapes that need to coloured either Red, Green or Orange depending on a specific cells value, 1 for Red, 2 for Green and 3 for Orange.

I have sort of managed to successfully complete this for 1 of the shapes, by using the RGB Fill option (Using 3 = Red, 4 = Green and 45 = Orange). But cannot for the life of me work out how to do this for multiple shapes using different cell triggers. Below is the code that I currently have and the spreadsheet that is linked to:

View 5 Replies View Related

Linking Text In Autoshapes

Jan 19, 2010

I've got a workbook for aesthetic reasons having text entered by users directly into protected autoshapes. I wanted to link text in one autoshape with another. If that was not enough I wanted to carry forward that text to another autoshape if a different autoshape did not contain text!

View 11 Replies View Related

Postion Autoshapes On Graph Relatively

Oct 24, 2006

I have a line graph which I have annotated using the autoshapes function in Excel. Various high points and low points have notes attached in order to make the graph clearer to clients.

Unfotunately, if I want to update the range of the graph (say to include two months instead of the usual one,) none of the autoshapes move.

View 3 Replies View Related

Use Cell Data To Format Autoshapes

Jan 19, 2007

I thought that I could use Excel... All I want to do is to use cell data to inform an autoshape, e.g. the length and width of a rectangle, etc. without resorting to VBA.

View 7 Replies View Related

Fill Color Of Autoshapes Condition On Cell Value?

Mar 2, 2013

fill color of autoshapes on condition depend on cell value

View 1 Replies View Related

Changing Fill Color Of Autoshapes Based On Cell Numeric Values

Jun 10, 2006

how I can change the color of an autoshape based on a value in a cell?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved