+ Reply to Thread
Results 1 to 2 of 2

Set a cell's default value when opening a file

  1. #1
    Registered User
    Join Date
    01-24-2015
    Location
    Andover, MA
    MS-Off Ver
    2013
    Posts
    4

    Question Set a cell's default value when opening a file

    Hi there,

    I have a workbook with cell A1 containing a drop-down list box. Users can choose how they want to "view" project data by changing this list box. Users can choose from "Project", "Phase 1", "Phase 2", etc.

    What I would like to do is to make sure that each time a file is opened, the user first views the data from the "Project" level.

    Is there a way for me to change cell A1 to "Project" every time I open my workbook?

    Thanks,

    JF

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: Set a cell's default value when opening a file

    In the workbook open event, place this bit of VBA code

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. opening odc:OfficeDataConnection and opening few columns by default
    By nihirshah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2014, 09:49 AM
  2. Update cell links between 2 excel file without opening source file
    By ferry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-26-2012, 03:03 PM
  3. Opening Workbook to a Default Cell
    By The Phil in forum Excel General
    Replies: 1
    Last Post: 11-04-2010, 07:13 PM
  4. Replies: 1
    Last Post: 01-26-2007, 02:25 PM
  5. Replies: 0
    Last Post: 03-08-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1