View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Locking the VBA Project

Any chance you have an older version of Google Desktop Search (or some desktop
search utility) running?

This was a problem with the google version (a longggggggg time ago). But it was
fixed pretty quickly. If you're running GDS, then try getting a new copy.



John wrote:

Hi Everyone
In the Project menu, I selected my project, right click "VBA Project
Properties". The Tab -Protection, I check mark "Lock Project for Viewing"
with password. That works fine.
Problem:
If someone use any macro in that workbook, then before closing the workbook it
request a Password and you can't cancel that menu.
I don't get it, maybe I'm at the wrong place to protect my project from view.
Can enyone enlighten me.

Regards
John


--

Dave Peterson