command

Morning, I wish to save a range from my worksheet in the pdf file type. The code below works fine with no errors etc but when i view the saved pdf i can see my command buttons which on the worksheet are in columns D & E When i press the command button i only wish to save what i can see in the...

Hello all, I have issue where one of our Excel spreadsheets suddenly shows following error message. External Data Refresh Failed This Command requires at least two rows of source data. You cannot use the command on selection in only one row. We were unable to refresh one or more data...

Can I create a comment template with a scroll bar using VBA which gets trigger through a command button

Can i have a command button on my dynamic worksheets to perform the below function (I have created a button to copy the work sheet, so the new buttons would be copied too ). 1. View button - to highlight or show a range of cells / table in the worksheet 2. Color button- selected cell would be...

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...

Hi all, I've been searching everywhere for a bit of code to build into a Command Button on my Userform which will basically take a screenshot (or however best it will work) of the UserForm as it is at time of click, and then pop up with the Save As box for the end user to select save...

I have lock certain cells in my workbook and added a password to it. I am looking for a way to disable the initial password prompt command for when another user opens the file. Thanks

I combine to cells into one using this command. I have two tables in the same structure. I use this command =a1&" "&A1 The first a1 is from table one the second a1 is from table two. The result is cell one 1 141 cell two 0 106 Whenever the first argument is >0 i want to color the cell...

Hello, I am currently fighting with the annoying command button/checkbox resizing issue. I put code in that, when clicked, moves the object 1 pixel and then back 1 pixel which has seemed to help the resizing issue during use. However, we are still coming across the issue where the workbook is...

Good day. I have 4 forms on one worksheet. I need to place a command button with each form. On click the relevant form needs to be saved as pdf on desktop. Please advice Regards and thank you in advance

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.

how do i force a command button to be pushed before exit.

Hello Friends, As the title says, I want to create a command button that when clicked, will generate a sequential number starting from 1. This is what I have coded for it Private Sub CommandButton1_Click() If CurrentRow = 5 Then ThisWorkbook.Worksheets("FR").Cells(CurrentRow...

Hi all, I have an issue that's been at a dead stop for 2 days now. Prior to my arrival at my job, someone wrote a python script to process some data files. What the script actually does is irrelevant. But the way it was written, the user would start the python exe and then copy>paste the...

Greetings! I have a shell command that uses curl to capture live audio output from a port on our call server. Sub RecordAudio() Call Shell("cmd.exe /S /K" & "curl 92.68.0.10:8888 > i:\voicetemp\voice.wav", vbMinimizedFocus) End Sub What I would like to know is; 1) how can I stop the...

Hi Expert, I am new in a Excel. I have created a trainee project for my learning. Now i want to sate a Save Command Button. Which VBA code i can do this. Thanks in Advance.

Hi I just watched a video. He created a form then inserted a label and a command button. Then he made the label Caption =1, then clicked on command button and wrote the code below. So when a user click the button the caption will increment by 1 Why is that? I changed the caption from 1 to Hello...

I am trying to figure out a code to reset about 10 columns of data back to 0.00 without wiping out the formulas contained in a few of the cells. Would I be better off just making a command to set specific values for each cell and copying in the formula there? Thanks in advance.

Hi I have created a dynamic form which will vary in height depending on user selection I have added a scroll bar so the user can scroll up and down the form i would like to add a Command button that would always be at the bottom right of form , is there a VBA code which can do this ? Thanks...

I am trying to get a worksheet to only select 4 criteria from a slicer that has over 100 options in VBA. I tried the method of just recording a macro but that was too long of a command and quit. Does anybody have any code that I could adjust / alter to get me in the right direction? Thank you.