locking project properties, and disabling shortcut keys

[Gunslinger]

Hi guys,
I have managed to get most of my project finished with a little help from great boards like these, but i am stuck on 2 things.

1) I think must be fairly simple, but i am missing the answer somewhere. I want to disable the standard shortcut keys when my workbook opens, and re-enable on exit.

2) in excel 2000 and later it seems you cant lock the project properties for viewing and still save in .xls format more than once, (i need to be able to do this, to update the info contained) so want to know if it is possible to protect/unprotect the project properties from withing the vba code when i open the workbook, and then again before i save it

TIA

I have done a search but could not find what i needed

[c.p.morris]

Hi Gunslinger,

I'm still learning myself so maybe someone with more experience may have a better answer, but for 2) the project properties are protected with workbook protection, so;

Public Const Pass As Variant = "mypassword"

ActiveWorkbook.ActiveSheet.Unprotect Password:=Pass

and similar to protect.

[Gunslinger]

thanks for the reply, that is something like what i did.

i actually switched to excelxp (one in office xp)

and that seemed to clear the problem, the problem was arising from locking the vba code and also the sheet and workbook, i never did work out what the exact problem was, but it seems to have been cleared up.