protected code allowing save

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

Guest

Why is it that the user of my Excel vba program can not save the Excel sheet
while the project is password locked ? Excel's message (not an error message)
tells him project must be unlocked before ? I can avoid the problem by
incerting the locked code in another Excel file and joinning them with
"Tools/References...." but there must be a better way ?
Thanks for your help.
 
I since found the answer myself: you would think that OfficeXP would
incorporate without conflict vba programs created under prior versions but it
does not in this case...I recreated the program in XP and save is now
permitted !
 
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 Project Has Protection? 2
Cannot view code in VBE of a file with no password protection 3
Modifying a locked/protected sheet 3
including macro in protected worksheet 2
protection not working 2
Protecting worksheet. 1
code for Allow Insert Hyperlink 2
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet 2

Back
Top