opening workbook

  1. R

    Macro to hide columns and provde an active cell in column Bs next blank cell upon opening the workbook

    Hi,I'm having some problem figuring out why the following code is not working. When I open my file, I want a macro to automatically hide columns G -Z if they were unhidden when the file was last saved. And I want the active cell to be the next open cell (or blank cell) in Column B (starting...
  2. B

    Vba: Opening a specific sheet in a workbook

    Thanks for looking at my post. I am trying to create a macro to open a specific workbook on a specific sheet. This is the file path were the workbook is located. H:\Burney Table\BURNEY 2\Operators Form\Burney2.xls
  3. Snakehips

    'Unreadable Content Error' -- Please Help

    I apologise if this is a bit long-winded, but can anybody explain the following? I have a large Excel 2007 workbook that is highly automated using vba. Over the last two years the file has been used successfully and develped on an ongoing basis. I do all the automation on PC - A, running XP...
  4. P

    Auto Value When Opening Workbook

    Hi All, When opening a workbook I want excel to automatically enter the value '1' into a cell of a certain sheet - for example cell A1 in sheet 'Mechanics'. How do I do this?

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...