I have been using Excel for some time now but just started working back with the Macros! Finally figured out that you had to turn on the Designer tab to get to some of the functionality of the macros. I havent been able to find ANYTHING ANYWHERE to tell me how to create buttons or Icons in the 07 Excel!
View 2 RepliesI have just made my first menu using VBA code. I would like to include icons on the buttons
View 9 Replies View RelatedI ran a simple macro that I created in my workbook, got a run-time error, clicked debug, clicked reset to stop the macro running, and now all of the icons in my workbook are greyed out. I can select cells, change worksheets, enter information in cells etc....just I can't save the workbook, or select any of the icons on my ribbon / in the office menu. Would really like to avoid terminating the application as I made a number of changes that I didn't save (doh doh doh).
View 9 Replies View RelatedI am trying to create a worksheet that has multiple radio buttons. Each radio button is linked to a Macro. I need there to be many buttons running down one side of the worksheet. Each button needs to perform a macro that is relevant to the cells in the same row that it is on.
Essentially what i am trying to do is make a macro that when the button is pressed copys data from H6 and paste it into B6. The button is situated above I6. I need a button for each row from 6 to 110.
While this macro is easy to create (i use the record button and then assign the macro to the button), i would have to do this 104 times and assign a new macro to each button.
Is there a quicker way?
I want to transfer my Excel-icons. Some of them are custom buttons where I have added user-defined functions. Is there any way I can do this? A list of icons with their function or purpose is OK as well.
View 4 Replies View Relatedmicrosoft toolbar buttons as I'm not especially artistic, but would like more choice when creating custom buttons ?
View 3 Replies View RelatedI like to mark names of persons who have done consecutively well in last two years with green circle and those who have not with red circle using Icon sets. I have created 4 columns and filled 1st with names (Text), and other 3 columns are filled with their output scores (Numbers) over last three years (2010-12). Like to highlight those names who have done well in last two years (2011-12) as compared to the third year (2010).
For example:
Names Score 2012 Score 2011 Score 2010
John 168 153 144 (should mark with green circle)
Steve 201 182 181 (should mark with green circle)
Mary 98 102 110 (should mark with red circle)
I've just finished writing some vb code that i need to assign to a button. Trouble is I select the control toolbox and put it design mode and all of the icons with the tool box are greyed out. pic attached below
pukks Auto Merged Post;Doh Doh and double doh!
Problem solved: I inadvertently had selected more than one worksheet tab and this was stopping me from placing a button on the worksheet.
Is there any method to change the placement of conditional formatting icons. By default, the icons appear at leftmost part of the cell. Is there any way the icons appear at the centre with percentages (see attachment).
File: Sales Comparison - New Outlets 2012.xlsx
I'm trying to create a formula where I can show the trend of two values from one month to the next that shows wheather the results went up or down in a positive or negetive value. For example:
If I have a transfer % of 18% in October and November MTD is at 17% - the arrow would then reflect downward showing in green, as the lower percentage is better. but I need the arrow to show upward in Red if say the value for November MTD was 19% instead.
I tried conditional formatting and attempted an "If" formula. I must not have all the information to create the formula as it errors out on me. I can create it if only looking to reflect one arrow...
=if(c3<b3,"")
I've created some macros in Excel 2010 which I've added to the Quick Access Toolbar and want to show them using some of my own icons rather than the ones that show when you click the 'Browse' button. There is no option to navigate to any other location.
Is it possible to access icons other than the set provided?
When adding functions to the quick access toolbars in Excel 2007 sometime they do not have an associated icon with the function. The icon shows as a green circle. How to change the icons and also to have a selection of icons like you have had in previous versions of Excel?
View 5 Replies View Relatedadding custom 16 x 16 buttons to toolbars, which weren't preset images or using the built in deisgner.
Was hoping there may be an add-in giving more variety of buttons or a way to import set images. Very frustrating as there are many microsoft 16x16 bmps / icons that would be ideal but the choice is extremely limited.
Is it possible to link 3 buttons to one macro.
What I'm trying to do is have 3 buttons:
Load Button:
-Which makes a copy of the current sheet, renames it, and freezes its values
Print Button:
prints all the sheets
Clear button:
deletes all of the named sheets
I'm sure this can be done with an if then else statement, but I'm just not sure how to set it up to capture input.
I can't write macros, so have to create them by actually recording the process. I did that just now and then copied it into the Command button. When I run it from Tools>Macros, it works, but when I run it using the Command button it fails.
I'm trying to copy and paste values current MTD figures (P18:P39) to previous MTD area (W18:W39), but the command button fails at this selection. Cells 28-35 are blank, but I don't think this makes any difference, as I've tried the command button with those cells zeroed out.
This is what I recorded initially; this works from Tools>Macros
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 04/01/2008 by Lucertola
'
'
Sheets("Reconciliation").Select
Range("P18:P39").Select
Selection.Copy
Range("W18").Select.....................
I want to put navigation buttons on each of the twelve spreadsheets, in one workbook, to run one macro. Is it possible to do this or do I need to follow the route of creating a separate macro for each (forms) button?
The route I have begun is to create this simple navigation macro is as follows.
Sub Goto200and100()
ActiveSheet.Shapes("Button 2").Select
Range("Q1400").Select
End Sub
Sub Goto100and50()
ActiveSheet.Shapes("Button 91").Select
Range("Q1400").Select
End Sub
Is there a way to add a reference to a button, which could show the user what the button does before he clicks on it. I'm thinking something similar to moving the mouse to a program in the Windows taskbar.
View 4 Replies View RelatedIs it possible to change the color of buttons or command buttons? There does not seem to be any place that allows this under properties for buttons, although there does for command bars. However, I've tried recording a macro as I change the color, but nothing get's recorded so I'm not sure what the syntax would be.
I have a spreadsheet with several buttons and I'd like them to change colors as they are pressed so it's possible to see what you've already done. And then, as soon as any other cell on the sheet is changed, the buttons reset color.
I need to have my macro select all buttons in the current row (including the button I clicked on and delete them. There are many rows with buttons. Each row needs to have this button. So I need it to be row specific.
I know that this is how to select the row that the button is in:
VB : sh1.Buttons(Application.Caller).TopLeftCell.Row
But I do not know how to select the buttons in that row. It needs to be included in this:
VB:
Sub move()
Dim shname As String, sh1 As Worksheet, lc As Long, rw As Long
Set sh1 = ActiveSheet
lc = sh1.Cells.Find("*", , , , 2, 2).Column
rw = sh1.Buttons(Application.Caller).TopLeftCell.Row
[Code] .....
After many attempts and alot of research, I have some more code for this problem: This deletes all buttons in the sheet:
VB:
Sub DeleteShapes()
Dim shp As Shape
Dim myVar As Shapes
ActiveSheet.Activate
[Code] .....
And this deletes the current button only:
VB:
Sub pressbuttons()
With ActiveSheet.Buttons(Application.Caller)
.Delete
End With
End Sub
Any way to either limit the first code to just a particular row, or expand the second one to the entire row.
I have an excel spread sheet set up with a button I created (a colored rectangle with text) that has been asigned a macro. When I print this spread sheet I do not want the 'button' to print on the page.
View 2 Replies View Relatedhow to give attractive colours to my ordinary macro buttons to which we assign macros
View 2 Replies View RelatedI'm using the With ActiveSheet.MailEnvelope command in vb to send an email and it works fine, but the range I am selecting includes macro buttons on the sheet.
It is possible to prevent macro buttons from been printed by selecting Format Control > Properties on the button and unticking Print Object (off by default anyway).
Is there any equivalent way of preventing macro buttons from appearing in emails when a range is emailed rather than printed.
I have several Activex buttons in sheet "Options" and I would like to automatically assign each button to the same macro "Run_Options", in order to execute the macro "Run_Options" when I do click over any button.
How can I do that with a excel macro?
I have a couple of combo boxes with lists to generate data for a dynamic chart. Elsewhere on the page I have hyperlinks to other tabs in the form of round button shapes.
When you select from the combo box, the selected text shows in the box highlighted, which is fine, but whilst highlighted, no hyperlinks work. You have to click a random cell on the sheet, and then click the hyperlinks again. Something thats fine for me, but not for my users as there's a lot of them and they won't realise. they will just report it broken.
I created two radio buttons on a spreadsheet where a user can select
one button for Yes and the other for No. When I right click these
buttons, I notice the names (shown on the left hand side of the
formula bar) are:
Option Button 3 (for No)
Option Button 4 (for Yes)
I'd like to create a macro that automatically selects the Yes or No
button depending on a cell value in another tab. If the cell value is
1, the macro should select Yes. If the value is 0 the macro should
select No.
I tried running the macro below:
Sub testSelectYesOrNo()
If Not IsEmpty(Sheets("Sheet2").Range("A1").Value) Then
Select Case Sheets("Sheet2").Range("A1").Value
Case Is = 1
Sheets("Sheet1").OptionButton4 = True
Case Is = 0
Sheets("Sheet1").OptionButton3 = True
End Select
End If
End Sub
But when this runs I get a "Run-time error 438 Object doesn't support this property or method"
When I click debug, the text "Sheets("Sheet1").OptionButton4 = True"
was highlighted.
I need a VBA code to remove multiple macro buttons from 31 multiple excel sheets with a single click.
View 9 Replies View RelatedI have two macro buttons on a page that hide and unhide columns. When I got to protect the sheet .. the buttons no longer work and ask me to DEBUG. Is there a way to have macro buttons performing tasks AND have the sheet still protected?
In the protect sheet window .. am I have ticked is
Select Locked Cells
Select Unlocked Cells
But these are ticked as a default.
I have a workbook which employs 4 different userforms. Navigating thru the workbook, the user ends up at a sheet with 5 macro buttons, allowing them to choose from several different functions. I added these to the worksheet using the "forms" toolbar.
My question is this: Is there anyway to change the color of these buttons, as I can with the userform buttons? Under "format control" I can change size, font, even color of font, but I can't change the background color of the button itself. Is it possible to identify those particular buttons thru VBA and adjust it's format?
I am trying to come up with some code to loop through all worksheets in the workbook and remve assigned macros from any buttons on each sheet
My code below. I type btn. and reviewed the items offered by intellisense, but nothing seemed fitting.
Sub RemoveAssignedMacro()
Dim wb As Workbook
Dim btn As Shape
Dim sht As Worksheet
Set wb = ThisWorkbook
For Each sht In wb.Worksheets
For Each btn In sht.Shapes
btn.
Next btn
Next sht
End Sub
I have a spreadsheet containing a group of Macro Buttons, each button has been assigned a macro that enters specific text in the selected cell when the button pressed.
But as you scroll down the sheet, the group of buttons is left above. Is there a way to make the buttons scroll down (or up) along with the spreadsheet ?