Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Macro is 'Unviewable'

  1. #1
    Join Date
    30th January 2003
    Posts
    44

    Macro is 'Unviewable'

    Excel 97 and I believe I created the Workbook using Excel 2000.
    I used File Save As in Excel 97 just to be sure.

    The workbook does not show as Read Only in it's Properties page.

    I open the workbook. I am prompted to Enable Macros and I select Enable.

    I hit the Run Macros button or Alt+F11 where I can view the attached macros but the Edit adn Step Into buttons are greyed out.

    I tried going in through Alt+F11 and Project Explorer and recieve the message that the macros are unviewable.

    Does anybody know why I can not view or edit ot step into the macros on this workbook and does anyone know if there is a way around it?

    Thanks in advance.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th January 2003
    Location
    UK
    Posts
    2,745
    Cross-poster? Read this: Cross-posters
    Struggling to use tags (including Code tags)? : Forum tags

  3. #3
    Join Date
    7th May 2004
    Location
    Libya
    Posts
    619
    Hi

    you might want to see Tools>Protect>Protect and share workbook

    Remove protect and share workbook
    cuz, once you protect and share your workbook, then your vba code becomes
    unviewable which appears in a message box

    might help

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th May 2004
    Location
    Libya
    Posts
    619
    Hi

    sorry, i was misstaken

    here is the solution, if..................

    SYMPTOMS;
    If you try to view a Visual Basic for Applications project in the Microsoft Visual Basic Editor, the following error message may appear

    Project Locked
    Project is unviewable
    even though you did not lock the project for viewing in the properties for the project. This message may also appear if you click VBAProject Properties on the Tools menu in the Microsoft Visual Basic Editor.

    CAUSE:
    This behavior occurs if you try to view a project that is in a shared workbook.

    WORKAROUND:
    You cannot view a project in a shared workbook. If you want to view a project in a shared workbook, turn off sharing. To turn off sharing, use the following steps:
    Open the shared workbook.
    On the Tools menu, click Share Workbook.
    Clear the Allow changes by more than one user at the same time check box, and then click OK.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    30th January 2003
    Posts
    44

    Solved

    Thank you Richie(UK) and Helmekki,

    The workbook was digitally signed by me on the Office 2K machine that I no longer have access to.

    The workbook was not set up as being a shared workbook.

    However, I did make it into a shared workbook. I received an error stating that I couldn't share it because it contained macros. Clicking the OK button saves the workbook anyway.
    I then removed the Share (that it alledgedly couldn't have) and sure enough I can View, Edit and Step into it's macros.

    Thank you very much.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 4
    Last Post: September 26th, 2007, 04:22
  2. Track Changes. Project Unviewable
    By legaboy in forum EXCEL HELP
    Replies: 11
    Last Post: June 26th, 2007, 10:58
  3. Replies: 2
    Last Post: October 3rd, 2006, 06:51
  4. VBA Project is unviewable??
    By simpsonc2 in forum EXCEL HELP
    Replies: 3
    Last Post: March 2nd, 2005, 22:25

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
  •  
porno