| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| allowing sort in protected worksheet | Excel Discussion (Misc queries) | |||
| Allowing sort of protected cells | Excel Worksheet Functions | |||
| Allowing insert pictures in a protected worksheet | Excel Discussion (Misc queries) | |||
| Allowing data entry in protected sheets | Excel Discussion (Misc queries) | |||
| Allowing hyperlinks an a protected sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
