+ Reply to Thread
Results 1 to 5 of 5

Macro Disappear

  1. #1
    Registered User
    Join Date
    03-25-2006
    Posts
    28

    Macro Disappear

    Hi,

    I recorded a Macro for my routine work and saved it in personal workbook.
    Upto yesterday it works O.K.

    Today macro disappear from Excel sheet.No more my routine work done. But it present in C:\Documents and Settings\Administrator\Application Data\Microsoft\Excel\XLSTART\personal.xls.

    I tried to record new macro but message appear "A personal macro workbook in start up folder must stay open for recording." I minimize security level also but no result.

    What should be reason and what should I do?

    Regards

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    Click Tools, Macro, Visual Basic Editor and in the VBE Project, select the current workbook.
    Best regards,

    Ray

  3. #3
    Registered User
    Join Date
    03-25-2006
    Posts
    28
    Hi,

    No result.

    I can't open my old macro and can't record new one.

    Regards

  4. #4
    Forum Contributor
    Join Date
    11-20-2005
    Posts
    256
    Hi dayaptl,

    Is the personal.xls hidden or is it closed? It should be hidden,
    Thx
    Dave
    "The game is afoot Watson"

  5. #5
    Registered User
    Join Date
    03-25-2006
    Posts
    28
    Hi,

    I hide personal.xls but no result.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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