|
-
May 19th, 2003, 01:23 AM
#1
Thread Starter
New Member
locking project properties, and disabling shortcut keys
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|