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
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
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
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
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
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
Mar 2, 2013
fill color of autoshapes on condition depend on cell value
View 1 Replies
View Related
Jun 10, 2006
how I can change the color of an autoshape based on a value in a cell?
View 4 Replies
View Related