Excel spreadsheet in locked Word form

[alpha]

I have set up a protected Word form that has an excel spreadsheet in
it. I have set up section breaks and have unprotected the excel
spreadsheet sections (3 in all). However, when I lock the form, it
does not allow me to access the excel spreadsheets. Any ideas?

 

[Robert M. Franz (RMF)]

Hi alpha

I have set up a protected Word form that has an excel spreadsheet in
it. I have set up section breaks and have unprotected the excel
spreadsheet sections (3 in all). However, when I lock the form, it
does not allow me to access the excel spreadsheets. Any ideas?

I don't think this is possible w/o code. You could unprotect the
document, do what you want with/to the spreadsheat, and reprotect it by VBA.

See for instance:

WD97: Some Menu Commands Unavailable (Document Protection)
http://support.microsoft.com/kb/180023/en-us

Greetinx
Robert