+ Reply to Thread
Results 1 to 4 of 4

HELP - I think I broke Exce

  1. #1
    Registered User
    Join Date
    05-24-2011
    Location
    Edmonton Alberta
    MS-Off Ver
    Excel 2003
    Posts
    6

    HELP - I think I broke Exce

    I had a fully funcitonal vba program - that as the file is close - it appends a couple lines to the next open row.... based upon the "thisworkbook.workbook_beforeclose" routine - it opens a sub in a module - which depending on how they have filled out the forum - it adds lines t


    I made a modification to allow me to acquire one more piece of data if the user has not already provided it...

    Now when it returns to the "PREVIOUS fully functional sub" it behaves as follows
    a) I can read (debug.print) activeworkbook.name
    b) I can read (debug.print) activesheet.name
    C) I can read (debug.print) activecell.row / column
    d) I can send values to specfic cells on the sheet (ie Range("A1000").value = "LAST CELL"
    e) I can move around on the cell (arrows) and verify where on the sheet I am...

    BUT
    I can not select/activate a cell
    Range("A1000").select -----does not move
    cells.select ------does nothing
    activecell.offset(1,1).activate ------- does nothing
    activecell.offset.font.italic = true -------- does nothing
    EVEN right clicking on any cell on the sheet and clicking Format Cells - does NOT call up the dialog box (ironically when I change to another sheet on the current workbook - I CAN call up the Dialog box for Format Cells)

    WHAT HAVE I DONE???
    HOW DO I FIX

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: HELP - I think I broke Exce

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    05-24-2011
    Location
    Edmonton Alberta
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: HELP - I think I broke Exce

    YES - I have saved / closed / Reopened - even reopened on a different computer (one running Window 7, one running XP) ---File is saved as Excel97-2003
    Last edited by shg; 05-24-2011 at 07:01 PM. Reason: deleted quote

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: HELP - I think I broke Exce

    Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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