Forum home » Delegate support and help forum » Microsoft Excel Training and help » MACROS
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MACROS
Resolved · Low Priority · Version 2003
Reply Tue 5 Oct 2010, 16:42Delegate Chris said...
Chris has attended:
Excel Advanced course
MACROS
Is there a way of locking a page and cells that contain macro caode, but the macro can still run?
For upcoming training course dates see: Pricing & availability
RE: mACROS
Hi Chris, thanks for your query. There are two things involved here. You lock a page but simply accessing the Tools - Protection options and setting the permission rights as required. However, to protect the VBA code, you need to right-click on the VBAProject heading in the Project Explorer panel of the Design Environment, select VBAProject Properties and protect the code from their. This prevents users from accessing the code but still allows the macros to run.
Hope this helps,
Anthony
Tue 12 Oct 2010: Automatically marked as resolved.
|