+ Reply to Thread
Results 1 to 8 of 8

Edit Sheet Code Via Macro

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    171

    Edit Sheet Code Via Macro

    hi,

    i need your help please, i want a vba code to to edit sheet code in excel.

    example; i have workbook "book1.xls", i want a macro to edit the sheet1 code via macro not manual.

    thanks.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Edit Sheet Code Via Macro

    can you explain why ?
    If solved remember to mark Thread as solved

  3. #3
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    171

    Re: Edit Sheet Code Via Macro

    i have a macro to replace the file everytime, so i dont want to copy the code & paste it to the new replaced file

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Edit Sheet Code Via Macro


  5. #5
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    171

    Re: Edit Sheet Code Via Macro

    it is ok, i solved it by copying & replacing the contents of the book instead of replacing the book itself

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Edit Sheet Code Via Macro

    Quote Originally Posted by boss1982 View Post
    it is ok, i solved it by copying & replacing the contents of the book instead of replacing the book itself
    As OP says that this is solved(explaining how (s)he solved it), there is no reason for us to continue on this.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  7. #7
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Edit Sheet Code Via Macro

    you marked as solved, but i'm not sure about that, did you edit code via macro ? if not the thread is not solved

  8. #8
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Edit Sheet Code Via Macro

    the title is "Edit Sheet Code Via Macro ", some users could open this thread to find solution

+ 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. [SOLVED] Help with macro Code edit
    By Caedmonball19 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-23-2013, 02:46 PM
  2. Every one can edit this Macro code please help me
    By esmatullaharifi in forum Excel General
    Replies: 4
    Last Post: 12-08-2012, 02:10 AM
  3. How i Can Edit this Macro Code
    By esmatullaharifi in forum Excel General
    Replies: 0
    Last Post: 12-07-2012, 09:35 AM
  4. Edit code to copy whole sheet
    By Sirishgreen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2008, 08:06 AM
  5. Edit this macro code to loop and end
    By GarToms in forum Excel General
    Replies: 1
    Last Post: 01-27-2006, 08:55 AM

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