ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Closing excel with a macro (https://www.excelbanter.com/excel-programming/318539-closing-excel-macro.html)

TJexcel

Closing excel with a macro
 
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.

Frank Kabel

Closing excel with a macro
 
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

--
Regards
Frank Kabel
Frankfurt, Germany

"TJexcel" schrieb im Newsbeitrag
...
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.




All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com