buttons

I have the code to make a button visible or not based on their user group. But is there a way to say if user = "poweruser" show all buttons?

Hi all, I have created 2 tabs Data and Form, Data Entry Form. With Name, Date, Item No, Outcome (dropdown) and Comment. Along with Save and Reset Buttons. Could someone please help with VB for me. Thanks JJSB

I'm trying to create a form that will allow the user to automatically fill in the beginning and ending date as search criteria using option buttons. Example, the user would select option buttons 1) Month To Day or 2) Last Month or 3) Year To Day or 4) Last Year, etc and the dates would populate...

Good afternoon, I have multiple macro buttons on one Excel sheet, which i would like to hide in a 'form' of sorts which is opened with one command button. when i activate the command button, a 'form' with all the macro's are displayed. Will really appreciate your assistance.

Hi I've been asked to create an interactive worksheet so that users can use "sliders" (by which I'm assuming spin buttons or scroll controls) can distribute £60,000 across up to 6 different sectors, one 'slider' per sector. I have: Cells B1:B6 linked to spin buttons 1-6 The £60 (I shrank it...

For some reason when I copy an item it is not showing up in my clipboard. It has been working flawlessly until now. When I copy a cell the Paste All and Clear all buttons are ghosted. It will copy and paste using the buttons on the toolbar but nothing shows on Clipboard pane. Thanks.

I am wondering if there can be buttons on multiple worksheets to hide or unhide a single worksheet? ThisWorkbook.Worksheets("jun payroll").Visible = xlSheetVisible for example the code above makes jun payroll visible using a button on sheet1, but can sheet2 have the a button to make the same...

Hi All, new to vba coding and have been wrestling with an issue. I have a large workbook with multiple worksheets. Each spreadsheet has information in it contained in option buttons (I think they are the Form Control type and not the ActiveX type). I am attempting to write code that extracts...

I have like 15 Modules in my workbook, I have no idea why 14 of them are there. I don't know that much about VBA so I don't know if they are needed. I do have a bunch of buttons connected to macros. Is this a glitch?

Hi, When I try and right click on the field buttons to hide them there is no menu. Everything else seems to be working fine, any ideas what's happening? Much thanks

I'm setting up a task list with several hundred tasks (each in its own row as you would imagine) and each with its own task number then for each task a column of status buttons "Complete" "Incomplete" "NotStarted" "Waiting on customer" I want to use radio buttons to set the status. So because...

Hi, I have the below code, which adds buttons(shapes) to every cell from range A2:A200. I would like this to be more dynamic, thus the desired result will be for this to add buttons based on an adjacent column, let's say Column B. So if column B has data until line 40 i would like to have on...

Hi! I have an obscure request. I do this thing where I like to use a pivot chart (with the expand/collapse button) as a fast way to "expand all" or "collapse all" for a related pivot table. Really, all I need is the Expand/Collapse button from the chart, so I always shrink the chart so I can...

Hi - I have a sheet in my workbook that is only a couple of buttons for macros for the user. Each button is supposed to print a different sheet. Problem is that both buttons only seem to run the same macro. Here are some screen shots of the situation: (thank you! thank you!!) THE BUTTON...

Super new here, but I've been dabbling with Excel for a couple of years. I've been tasked with creating a group sheet. Clicking 1 of 5 buttons will automatically color the background of a cell, according to the button clicked, if I enter 1 of the 6 identifiers. This is the kind of flow I was...

I'm trying to make 2 buttons for a query that will go in a switchboard. The two buttons I'm trying to make are going to be called Add and Cancel. Add, will obviously add the new records created in the form, and Cancel will just close the form. My issue is I don't know how to go about...

Hello Fellows, I have created a RibbonX dynamic buttons. The progran reads a list in Excel column to create the buttons for the control. The entries in the Excel column are used as labels for the dynamic buttons. A common Callback routine is used for each button. That is, the butt******* for...

I have sheet that is designed for end users to only be able to put information in unlocked cells. I want them to then be able to click the corresponding the button that puts this information into a master sheet. THEY ARE NOT TO BE ABLE to edit any sheets or any buttons. I have around 200...

Hello All! I have a macro that sorts a raw data set and adds a bunch of buttons. Those buttons call methods that search for a specific data set, sort data, or build graphs. It all works great when used on a single computer, but I'm having trouble if the document is emailed. If I run the macro...

I'm using command buttons for process control in a spreadsheet. Using vba to enable and disable buttons to keep the user moving along. Each button performs a different vba routine. Problem I'm having is the buttons resizing themselves with each click. Specifically increasing in size, but the...