running macros on protected sheets

Hi,

I've got a bit of code that unprotects the sheet and protects it again, so I can use macros,

Please Login or Register  to view this content.

however, the problem I have is that people can go in a view the password. I've tried assigning a VBA protection password on the code itself but it seems that you can't save a workbook like this.

Is there any way round this. The code works brilliantly but don't want the uses to be able to see the password.

Any ideas would be much appreciated.

Thanks
Harry

Good morning baz0912

You will need to password protect the VBE. From the VBE go to Tools > VBAProject Properties, Protection and insert your password.

Caveat : Excel's password protection is not great (actually it's a disgrace) and can be removed in the twinkling of an eye, so don't trust anything too personal to it. Microsoft's view is that it's there more to prevent accidental erasure of important information that to protect sensitive information.

HTH

DominicB

Hi baz0912

The problem I have with this is that the users can't save workbooks with this protection in place?

Which protection? The VBE password protection?

Why can't user's save it? What happens?

This shouldn't cause a problem and I've never heard of it happening before. Can you elaborate a little.

DominicB

Hi baz0912

You must be saving as an old version of Excel. From you file go to File > Save As. What does it say in the box marked Save as Type? Unless you are saving for backwards compatibility puposes, it should say Microsoft Office Excel Workbook (*.xls).

HTH

DominicB