add button

Hi All. The below code was working fine until I added in the Worksheet Protection. What I found weird that stepping through the code the worksheet is definately unprotected. The Thetarget value is a little "switch" that I put below the added button so if that is 1 the macro will not get...

I'd like to add a number in Sheet1 column A1 "6412" for example and flash fill the number down to auto fill cells by multiples of four. is that possible?

Hello Community, I am familiar with basic EXCEL functions but a totally newbie when it comes to VBA or macros. However, I'd like to prepare the following data collection tool for a study project. Introduction: I'd like to prepare an organizational survey with EXCEL. Since managers have chronic...

Hi, Is there a way of adding data that has been selected as drop down boxes into a table? - I have added a list box as a data validation in cells D3, D5, D7, D9 - Can I add a button that takes this data and adds it to a table and then deleting the data in cells D3, D5, D7, D9 to allow the form...

I have an excel file where the first sheet is an index of all the sheets in the workbook. I need a macro that adds three buttons to every sheet except for the first sheet (the index) I will need to run this macro again and again as new sheets are added. Rather than searching for the new sheets...

Hi Everyone, I have a data in excel and has a very long data in columns and it took some time to scroll left and right and it is very time consuming. And it came up to my mind, that is there anyway that by putting some button to click it and it will go some certain columns like from BC to BS and...