active sheet

I have written some code that runs about 400 lines of code in one worksheet, then 400 lines of code in another worksheet ("Calendar"), and finishes by returning to the first worksheet. When I run the code, it takes about a second to process. There is a flicker for about a quarter-second where...

I have a userform in my workbook with a button to access it on twenty different sheets in the workbook. Currently the userform will only populate the sheet titled "Blank1". How can I change it so it will populate the active sheet without naming it? So no matter what sheet I'm on when I hit the...

Can anyone help me out with this code: Sub HideAllButOneSheet() Dim SubJ, Recip As String SubJ = "HE ACTUALS" Recip = "derek.hughes@vcsu.edu" ThisWorkbook.SendMail Recip, SubJ MsgBox "Email Sent" End Sub It sends the whole workbook and I only want it to send the active sheet.

I have a list of names of pictures in a column on a sheet. When I click on any list item, the Selection_Change event loads the selected picture into a userform and displays it. This takes focus away from the clicked cell so I can't then select the next cell up or down with the arrow keys. The...

Hey all, I have a UserForm that contains checkboxes... the code attempts to transfer the data from the checkboxes to the first empty cell (in a certain column) in the Sheet named "Shipments"... yet when I enter the data... it always goes into the sheet which is active... not only the Shipments...