View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TJexcel TJexcel is offline
external usenet poster
 
Posts: 1
Default 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.