Closing excel with a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have enable the Locked for Viewing feature in VBA to protect my code from
being viewed and changed. But when I close the worksheet with code via a
command buttom, the spreadsheet closes but a password box comes up. The
password box is for access to the code. If I turn the "Locked for viewing"
off the problem goes away, but my code is exposed. Please help, can someone
help me solve this problem?
Also this never happen until I installed SP3 on my Office XP.
 
Hi
have you installed Google Desktop Search. If yes uninstall it and try
again
there have been some reports about this error lately.
You may also fill out a bug report for google
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
VBA Code Locked for Viewing 7
Cannot view code in VBE of a file with no password protection 3
Macro to lock project from viewing 1
Locking the VBA Project 13
including macro in protected worksheet 2
Close almost all workbooks 2
Excel 2007 - VBA Password Input shows after Excel is closed 3

Back
Top