workbook open

I changed a user form name and now the user form will not start when I open the workbook. I use the "Workbook Open" event in the "Thios Workbook" section viz: Private Sub Workbook_Open() fm_flange_1.Show End Sub The new user form name is fm_flange_1. What do I need to do to get this to work...

Hi all, I have a textbox (active x) on a worksheet I want this to be populate by a range (Country_RNG) when the workbook opens Private Sub Workbook_Open() Sheets("Front Page").Select Country_CBX.List = Range("Country_RNG").Value End Sub This is on the 'This worksheet' object. Im getting...

I have a workbook open macro that I have been using for a while and tweaking every now and then but I am having truble with trying to check if data entered into an input box is in a range of cells on the sheet and if it is not then add it to the next blank spot in that range (the last 3 or 4 are...

Hi, Is there any way to capture the event of when a new workbook is opened in the excel application ? I am running some code that requests data from another application. The way that application returns the data is by opening a new workbook (with a random name) with the data in it, about 30...

I have a macro in a workbook with code in the Open event that opens a workbook: daily.xls In the daily.xls file there is a UserForm with code. In the UserForm code there are private subs. (private sub name: Update) How do I have my initial workbook open the daily.xls file and run the private...

I've been trying for a while to write a code that will copy the data between two workbooks (lets say A and B) but will only copy columns A2:T2 and then down the used range. I am unsure as how to state that in the code. Does anyone have any examples of code they got to work for copying between...

Hey guys, This may be a dumb question because I've been looking for an answer all over the internet and can't find the problem mentioned anywhere. I'm relatively new to Excel VBA though, and I'm trying to create two events for a single workbook. Is this possible? I have one workbook open...

I created a summary worksheet but now I need the data in a new file. This file would get updated each time the original is modified. I have the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "O16" And Target.Value <> "" Then...

Hi, I have a workbook where the sheets are all protected and I want to stop users scrolling up or across beyond the limits of the input areas. I have used the following code (or variations of)... Private Sub Worksheet_Activate() Me.ScrollArea = "A1:G32" End Sub This works fine except that...

Hi, I've got a problem and I think its one of those simple solutions that is impssible until someone points out the obvious! Basically I want to check to see if a certain worksheet has an autofilter applied to it when the workbook is opened, and if there is I want to remove the autofilter...