toggle

Hello all! Trying to add some dynamics into a chart that our office uses in some reports. We have a few areas of the chart that will be used in some reports and not others, and I would like to have the option to hide and show those sections (rows) at will. I would prefer not to manually show and...

Hi guys, Pretty easy one for you, I'm sure. On the sheet "Impact", I want some code to toggle the hiding of rows 1-15. I have a button which I want to assign the macro to. If rows 1-15 are already hidden, I want to unhide them. If rows 1-15 are visible, I want to hide them. Any ideas...

Hey guys, I've been racking my brain trying come up with 2 separate macros: macro 1) toggle cell border between borders: top, bottom, left, right, outside, top and double bottom, none macro 2) toggle cell interior color between: yellow, light gray, light blue, no fill I tried using the "case"...

I have a simple query setup. =Query('Data'!A2:O, "select A,B,C,D,K,L,N where K='No'") I would like a way to toggle this query off and on. I tried putting a checkbox in A2 and added IF(A2="True" before the query but that doesn't work. Almost got any ideas? Ultimately I'd like to have this query...

Hi, I try to untoglgle a button after use. My xml code is [/URL][/IMG] and I tried this in VBA Sub TbtnManClick(control As IRibbonControl, Pressed As Boolean) Dim Manvalue As Variant Manvalue = InputBox(Range("LgMan"), Range("LgMan"), Range("RngMan")) Range("RngMan") = Manvalue 'Untoggle...

Hi all, I am trying to automatically convert a few 'durations' (in [h]:mm format) located at range D17:D21. I need to use some toggle switches at E16:I16 to select what ratio to be displayed at cells E16:I16. e.g. at E16, the switch should either show Ratio 0.75:1 or Ratio 1:0.75 and that way...

I currently use the following to automatically refresh a group of pivot tables: Private Sub Worksheet_Change(ByVal Target As Range) Dim ws As Worksheet Dim pt As PivotTable For Each ws In ActiveWorkbook.Worksheets For Each pt In Worksheets("QRY_Open").PivotTables...

Hi Folks, If I have the Find window up and want to switch focus to the worksheet is their a keyboard shortcut so I can toggle between the popup and the worksheet? Martin

Hi All, I'd like to use VBA to toggle a shadow on the currently selected shape... I've tried a few things, but somehow I can't seem to get to the currently selected shape. Might someone give me a leg up? Thanks so much! R

Hi, Is it possible to add 2 macros to the toggle button, so when click on a macro runs and when clicked off another macro runs. I have all the xml and vba code setup for the toggle button to work, however I am not sure how to add macros to the toggle button. can someone help with this please

In Excel 2010 I have a range of cells that each contains a formula. This range of cells is counted using '=COUNT("Range")'. I would like to use VBA to exclude a cell from being counted, but also being able to change my mind and include it again. So I want to be able to toggle if a cell is...

I have two dependent drop down lists and I want to insert a function/macro to toggle through each possible option on the drop down list at random. Any help would be greatly appreciated!

I have a dataset that contains in the first column the name of a company, column b contains two options that apply to that company, so each company could be in the sheet at least twice, then in column c to g contains financials that are associated with each option (column b). I need to...

Hi everyone, I have the below macro which is a conditional format for certain cells, that is part of a larger macro. I am just wondering if there is a way to also insert a toggle button via active X I am thinking to be able to turn this function on and off?? If so, what code should I add to...

Hello, I'll start by saying I'm a noob when it comes to VBA coding in excel, but I'm trying to learn. Hoping you guys could help me code a toggle button. When the button is depressed I would like the font, fill color, and border to be white in rows 23-35, on that worksheert, so it is not...

Hi, I have a button on my spreadsheet that I want to make toggle a filter in column AP... So when clicked once I want it to filter everything but blanks in that column When it is clicked again I want it to clear that filter for just that column. I'm sure it's pretty straightforward, but I...

Hi, I have created a toggle button in xml which works ok but what I would like to do is enable two other buttons on the ribbon If toggle button is pressed and disable the same two buttons when toggle is un pressed. Can some one help with this please?

Hi. I would like to create a toggle button but instead of selecting the columns to toggle (as per below "Range("D:E").Columns.Hidden = Not Range("D:E").Columns.Hidden") I would like to toggle on cell color so then you can quickly fill and unfill the cells in row 1 and toggle would use a color...

I am new to Mac, and don't know how to toggle between open excel workbooks. The research I have done online is dated more than 5 years ago. And their tips didn't work. Anyone know how to toggle between open workbooks on a Mac? (Like using the CTR+Tab key on a PC?) Thanks for your help!

Hi, Is it possible to press a toggle button to activate a send key button then press that button (i.e. directional buttons - Up Key, Down Key, Left Key, Right Key which will have a macro assigned to each) but be able to repeat the key button press as many times as desired until the toggle button...