+ Reply to Thread
Results 1 to 2 of 2

cannot run macro if personal.xlsb is hidden

  1. #1
    Registered User
    Join Date
    08-11-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    45

    cannot run macro if personal.xlsb is hidden

    Hi

    I have a simple formula I created using VBA but the problem is I cannot use it for some reason if Personal.xlsb is hidden.

    I can see the code in VBA Editor but I cannot use my formula in the spreadsheet. If I unhide Personal.xlsb everything works well but of course I would like to keep it hidden. I tried deleting personal and creating it again but nothing seems to be working.

    Please help!

  2. #2
    Registered User
    Join Date
    01-31-2014
    Location
    East Coast, England
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: cannot run macro if personal.xlsb is hidden

    You could try using something like this i am not sure it is correct but you should get the idea.. im very new to VBA. maybe someone with better skills can type the code up but basiclly you want to make a macro that turns off screen updating then unhides the personal workbook runs the macro you want to work and then re-hides the workbook before puting screen update back on.

    Please Login or Register  to view this content.

+ 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. Automatically close hidden workbooks (Personal.xlsb)
    By JonSnow in forum Excel General
    Replies: 5
    Last Post: 01-29-2014, 09:24 AM
  2. Add procedure to PERSONAL.XLSB with a macro from another workbook.
    By dimattia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2013, 10:21 AM
  3. Run-Time Error 1004 When Running Macro from Another Personal Workbook (xlsb)
    By vcs1161 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2013, 12:05 PM
  4. DELETE the Personal.XLSB macro I created - can't get rid of it!
    By Cut2please in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2013, 07:51 PM
  5. Move or copy macro from Personal.xlsb to workbook
    By kazphilips in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2012, 05:26 PM

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