Disable functions for workbook only?

[ajwhipple]

I've been using the following types of commands to disable cut, copy, paste, activities within a spreadsheet:

Please Login or Register  to view this content.

When the user closes the workbook, I want to restore those functions, however Excel seems to hold the settings until I restart the application. I know that I can write a macro to switch everything back on just before the workbook closes, but I'm wondering if there's a way to structure the commands so that they apply to the workbook only.

Any advice is appreciated.

[ukphoenix]

If your using a macro on opening to disable these functions, why would you want to turn the functions back on when closing, because surely when you open the workbook again its gonna disable them again ?

[ajwhipple]

Some spreadsheets require the use of security features, but most do not. I've built those features into the required workbooks, and they are enabled when the workbook is opened. When the user is finished with that workbook, I want them to have full access to the application features for the rest of their activities.

[VBA Noob]

Links may help

http://www.xcelfiles.com/VBA_Quick13.html

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

VBA Noob

[ajwhipple]

Thanks. This is all good information. I'll review and see if I can make this work for me.

I've noticed several security macros disable the +DEL and either +INSERT or ^INSERT key combinations? Why is this? What do these combinations allow the user to do?

If I'm following it correctly, the ^ symbol represents the CTRL key. Is the + symbol just a shorthand that mean anykey + anyotherkey?