Macro help

[IrvineP]

Hi peoples, thanks for the help in advance.

I've got a spreadsheet that has a number of simple macro's in. It probably has about 15-20. 3 of these will actually call all the others.

The workbook has to be updated by other users and so I would like the macro's to exist - but I don't want other users other than myself to be able to edit the macro's - and if truth be told probably see the 12-17 that are called.

Is there any easy way of doing this?

Cheers

PEte

 

[Damon Ostrander]

Hi Pete,

Yes, you can simply password protect the VBAProject. It will be usable but not visible unless unlocked with the password. To do this, in the VBE go to Tools > VBAProject Properties. Go to the Protection tab and check the Lock Project for Viewing checkbox. Then enter your password twice and click OK.

Damon

 

[KenWright]

Just to add to what Damon has advised,

Go into the VBE (ALT+F11) and where you see it say 'Sub xyz()' blah blah, change that to 'Private Sub xyz()' Any macro you do this for will not appear in the Tools / Macro / Macros dialog box. You can still call them from another sub, just not see them in the box.