buttons

I have created some buttons via Form Control and assigned macros to them. I just noticed that many of them literally disappeared. I closed Excel and then reopened the file, and now the buttons show up. I am glad they are working again, but any idea why they would disappear to begin with?

hi guys, i would like to make two buttons, one at B1 and the second at C1. if you press B1 button must show number 1 at A1 or if you press C1 button should show 2 at A1. The second issue is that i would like to have these buttons in columns because am interesting to have data in A1:A30. thanks...

Hi All. I created a user form with multiple toggle buttons. Each buttons represents a sheet in the spread sheet. I would like to be able to only print the pages of the buttons that the user selected. At first I tried to use the respective click button subs to select the sheets. It only select...

Hi, I have a workbook which I use savecopyas often and with a file size of around 6MB, it's using up space fast. Source workbook contains many sheets/macros/formulas And I only need to save 1 sheet (Main) to a new workbook and remove buttons + turn sheet to values if possible. Note the sheet...

Hi there! I have some problem and I will wonder if you help me on this. I have a calendar with 12 command buttons with name month_1, month_2 , ... ,month_12 and almost 365 command buttons with name day_1_1, day_1_2, ... ,day_12_29 and also 365 cells in a separate worksheet relative to this...

I just bought the latest version of Excel and I use to be able to step through my macros with F8. It no longer works. Also My control buttons don't work. Has it changed?

Trying to open a website that has a table, navigate to the download button(s) and export the table to Excel, using Chrome. I can open the website, but that's as far as I could ever get.

Hi all, My current sheet has a macro that uses a userform to add a new named sheet (eg. 'Coats'). Is there any code i can use in my userform module to then add some code automatically to the coats worksheet module as it is inserted? The code i'm looking to add to the module is Private Sub...

Hi All I have a spreadsheet with a row of Toggle Buttons. The toggle buttons are to indicate if a task has been completed. When clicking the button it says 'YES' and using conditional formatting, turns the whole row green. I have some VBA attached to the toggle button to determine the colour...

I have a label that changes occasionally. If this label is one thing, I want the CommandButtons in my userform to be locked... If it is the other option, I want the command buttons to be unlocked. I've tried to use Label1_Change() but it doesn't seem to work. Any ideas on how I might achieve this?

Hi, I have an excel file with 5 buttons and each of them has a separate vba module but I want to display only one button on load of an excel. Other 4 buttons should load on click of the fifth button which was visible. Can anybody please guide me how to get this thing done? Thank you

Hi all, again. If I can't do the simple thing, I will NEVER ever stand a chance at learning how to correctly code. Ok. There's a form that loads when a spreadsheet is clicked; Private Sub Worksheet_Activate() CustForm.Show End Sub This form has 4 command buttons. One of these buttons...

I have buttons on my worksheet that changes size when they are clicked. What's happing? I do not have any code directing them to. The columns/rows that they are in do not change size so that's not it either. they get smaller when clicked (each time they are clicked) Thank you for your help

We use an online database system that we created for our company. I create Excel workbooks for entering data and generating certificates. The workbooks have several buttons on several worksheets that are used to navigate through the worksheets and for running various macros in the workbook. Once...

hi All, I have a problem with the workbook I work on. In one Tab (Tab1) with command buttons (Names A,B,C and D). The second tab is a table with a data for A, B, C and D. I want to hide all rows with 0 in column C in Tab2 if I press command button 1 I have a code which works in the development...

I have several buttons on on work sheet. At some point, they decide to start resizing themselves. AN internet search seems to indicate this is a common problem. I am not married to command buttons is there an option for these macros that would avoid the automagically resized buttons. Ian

Hi. I am having trouble visualising the best way forward for this problem. I currently have a master workbook with three sheets A,B,C Within this master workbook, there area a number of buttons and VBA code On sheet "A" , and one for example can duplicate sheet A, to A1, A2 etc. I then...

Hi all, I am trying to develop a time punch userform where my people only need to click the buttons to log in and out. And I want to track it daily. My work is in progress. Please see attached 3 sheets. And now I am so stuck...

Hello guys, I have a few questions about excel on windows and on Mac. I have a file that has buttons in it, on windows they work fine but on MacOffice they wont work. I've read that ActiveX wont work so I have to use the form buttons. My question is. Activex buttons give me more options to...

My wife is a second grade teacher who needs some way to check the reading fluency level for each student. The idea is to type a story into Excel. A different word will be entered into its own cell. For example: A:1 the; A:2 dog; A:3 ran; A:4 away; A:5 . I would like to create an invisible...