How do you password protect a Macro in Excel 2003?????? Anwser needs for A level ICT coursework?

Answer 1

When you select Tools -> Protection
MS Excel asks you what do you wish to protect. You can protect Edit, Add, Delete etc.

Once you set the protection level your macros in the Workbook will be safe from Editing, Deletion etc.

Answer 2

Password Protect Excel 2003

Answer 3

You could either password protect the whole worksheet or, after If you just used security under Tools, Macro, that would be too easy for anybody to reset the level from high to medium or low so, protecting the whole worksheet is the answer. This is a two pronged affair, you have to unlock the cells which you need open to enter data into, but leave locked those cells with formulae in. So, highlight the cells where you want to be able to enter or edit data, right button, format cells, protection and untick the locked cells box. Then Tools, Protection, Protect Sheet, type your password and OK.

Answer 4

Open up the Visual Basic Editor from Excel by pressing Alt + F11 or by going to Tools > Macro > Visual Basic Editor.

In the top left of the Visual Basic Editor screen should be a window called the Project window. If it is not there, go to View > Project Explorer and that will bring it up. In the project window, select the project that contains your workbook. For instance, if your workbook is called "Book1" then select the line that says:

VBAProject (Book1)

Then right click that line and select VBAProject Properties... from the list. In the VBAProject - Project Properties Window that pops up, select the Protection tab. Place a checkmark, in the "Lock project for viewing" checkbox. Then below enter the password you want in the two textboxes. Make sure you can easily remember the password or to at least write it down. Then click OK. Afterwards, just close the Visual Basic Editor window and you are done.

The macro code must be locked from Visual Basic Editor. The macro code cannot be locked directly from the Excel window.

Answer 5

Presume though you mean that you don't want people without the password from running the macro? You'll have to put some VB script in the macro to test if the person knows the password. If you can't script it yourself then google it, there is example script out there. Or teach yourself how.