Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlocking a Project
I've been asked to have a look at a Excel workbook created by a former
employee that is used by a large number of people in my organization. There is no dcoumentation. Through the VBA editor I am unable to look at any macros the developed may have created but instaed get a popup message box that the Project is Locked and Unviewable. The developer told me he put no locks on the project other than what may have been available through an add in "ASAP Utilities". I downloaded this but it doesn't seem to make a difference nor can I find any menu item in ASAP related to Project locking/unlocking. Excel help hasn't provided much useful info either. If someone can at least direct me how to lock/unlock a project it would be a start. TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlocking a Project
Dear Ralph,
Had a similar problem, found these links helpful. Kind Regards, http://www.hhdsoftware.com/ http://www.schmittis-page.de/index.h...l/vba/t48e.htm Hope they help you out. Andrew Richards Gatton Australia |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlocking a Project
I have been in contact with the author Once I got a hold of him he was quite
helpful. The solution was to remove disallow "share workbook" in the tools menu. Once that was done the "Project Locked" message box disappeared. "Ralph Heidecke" wrote in message news:43b2cd74$1@flight... I've been asked to have a look at a Excel workbook created by a former employee that is used by a large number of people in my organization. There is no dcoumentation. Through the VBA editor I am unable to look at any macros the developed may have created but instaed get a popup message box that the Project is Locked and Unviewable. The developer told me he put no locks on the project other than what may have been available through an add in "ASAP Utilities". I downloaded this but it doesn't seem to make a difference nor can I find any menu item in ASAP related to Project locking/unlocking. Excel help hasn't provided much useful info either. If someone can at least direct me how to lock/unlock a project it would be a start. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project. | Excel Programming | |||
Locking and unlocking a Excel project for viewing | Excel Programming | |||
Assigning the Help 4, *.HLP file for a project programmatically in a protected Project | Excel Programming | |||
Locking/Unlocking a VBA Project in 2000 vs '97 - Difference? | Excel Programming | |||
unlocking a project in VB(A) | Excel Programming |