ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   protected code allowing save (https://www.excelbanter.com/excel-programming/315321-protected-code-allowing-save.html)

André Boileau

protected code allowing save
 
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.
--
Popsie

André Boileau

protected code allowing save
 
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 !

"André Boileau" wrote:

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.
--
Popsie



All times are GMT +1. The time now is 09:11 AM.

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