Closed Thread
Results 1 to 3 of 3

Lock a project using a macro

  1. #1
    Registered User
    Join Date
    06-23-2006
    Location
    Belgium
    Posts
    7

    Lock a project using a macro

    Hi,

    Can anyone tell me how to protect/lock a project using a macro

    Thanks

    One or many steps behind

  2. #2
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    Hi

    As far as I am aware the project lock has not been exposed to VBA (ie there is no VBA command such as LockProject) as a security measure, therefore should you wish to do this using VBA the only way I can think of would be to use SendKeys (which is not a 100% reliable method at best).

    Richard

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Closed for cross posting.

    Please read forum rules below. If you agree to them PM me and I will unlock thread

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

Closed 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