workbook_open()

Hello, Workbook_Open() is not working anymore. I removed a class module from PERSONAL.XLSB which had only one line: Option Explicit and then some commented code. This was related to an old macro which was not in use. Reverting this makes no change. I searched for forums and made sure that I...

Dear all, I write some code to expand ribbon when open workbook (in ThisWorkbook): Private Sub Workbook_open() If Application.CommandBars("Ribbon").Height<=100 Then SendKeys "^{F1}", True End If End Sub But it not working. I think because of loading time when file opened. Could someone has...

Hello, I am working on a Workbook_Open formula. Right now the formula works, but it's not forcing Sheet 11 & Sheet 12 to do something. Normally on those Sheets once you click V6 (which is a data validation drop down list) it activates a VBA code for Worksheet_Change which tests if V6=V2 on the...

Hello, I figured out my last post to make a drop down list default to a certain choice when opening up excel. However I could not edit my post to state so and then ask my follow up question that I have to now to complete my workbook for users. My question is as follows: How can I cobble...

Hi all, I have a shared workbook which I would like my collegues to keep open at all times, and they can add information to it via a userform. In order to ensure there aren't any data clashes, they have to "refresh" the sheet before adding which uses this simple code: Sub Refresh()...

Hi to MrExcel staff and users, As my username states, I am not a profesional programmer but rather a VBA amateure so - be gentle :) I have been struggling with a protection issue in an Excel VBA project I am doing and just can't seem to figure out what the heck is going on in my file. The...

Hi All, I'm semi experienced with VBA codes but have never written one to run upon the document opening. I tried following this guide Run a Macro Automatically on Opening Excel Workbook - VBA Examples but couldn't get it to do what I want it to do. 1. Essentially I want users to have the...

I want to calculate the number of days until deadline. Column G15:G1000 is set as the deadline date. I have a similiar code in a worksheet_change script, and it works fine. Also, I'm relatively new to the whole "VBA experience", and haven't really used Workbook_Open() before.:) Sub...

I am trying to make a login prompt when opening a workbook. In this workbook I have a Sheet labeled, "Userbase". In the "Userbase" sheet there are 4 columns. In cell "A2", the text "First Name" is set. In cell "B2", the text "Last Name" is set. In cell "C2", the text "Logon ID" is set. In...