+ Reply to Thread
Results 1 to 6 of 6

Modifying VBA code so calender populates on certain columns and not whole workbook

  1. #1
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    324

    Modifying VBA code so calender populates on certain columns and not whole workbook

    HI

    Hope all is well,

    I really need some help and i have novice VBA Skill

    I have created a calendar within my excel doc, which works on any sheet when you do the following “ctrl+shift+C”,

    However i would like the calendar to only open up when you select the following columns F&G on tab Issue Tracker and column G& I on “Gantt Chart” tab

    Would appreciate any help Available

    Regards
    Last edited by masond3; 06-28-2013 at 10:19 AM.

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Modifying VBA code so calender populates on certain columns and not whole workbook

    This maybe,
    Double click column F or G.

    Please Login or Register  to view this content.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  3. #3
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    324

    Re: Modifying VBA code so calender populates on certain columns and not whole workbook

    HI JapanDave

    Thank you for swift response

    Do i need to add this VBA to the sheets where i want to the calender to apply to ?

  4. #4
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    324

    Re: Modifying VBA code so calender populates on certain columns and not whole workbook

    Bump Thread

  5. #5
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Modifying VBA code so calender populates on certain columns and not whole workbook

    Yes. When you doubleclick in those columns the userform will show.

  6. #6
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    324

    Re: Modifying VBA code so calender populates on certain columns and not whole workbook

    JapanDave, you are a * , thank you very much for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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