Consulting

Results 1 to 3 of 3

Thread: Solved: Unwanted Microsoft message

  1. #1
    VBAX Mentor
    Joined
    Sep 2004
    Posts
    431
    Location

    Solved: Unwanted Microsoft message

    I had to eliminate few columns from sheet "Template" and what I did was create a new sheet ... and pasted to it what I chose from sheet "Template" then deleted "Template" and renamed the new sheet "Template".
    Hope this all make sense to you.
    When I run my code I get this warning.... I'm not sure what it is and how to address this problem.
    Thank you


    Thank you for your help

  2. #2
    VBAX Expert
    Joined
    Feb 2005
    Location
    Nanaimo, British Columbia, Cananda
    Posts
    568
    Location
    Hi n,

    Looks like there is a name in the workbook that hung on.

    I would go to Insert menu, names define and redo the names.

    Post an example workbook if you're not sure how to do this.
    Cheers,

    dr

    "Questions, help and advice for free, small projects by donation. large projects by quote"

    http:\\www.ExcelVBA.joellerabu.com

  3. #3
    VBAX Mentor
    Joined
    Sep 2004
    Posts
    431
    Location
    Bonjour Westerner,
    The redoing of the names did not do it.
    What worked is redoing sheet "Template" from scratch
    Have a nice weekend
    Last edited by ndendrinos; 09-12-2009 at 06:58 AM.
    Thank you for your help

Posting Permissions

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