Error- Running a Macro on a Protected Sheet

This is an issue as I know that if I don't password protect the tab (sheet) I'm going to have the user play around with the cells, etc. But the thing is that if I password protect the sheet then I get an error message when I try to run the macro.

As usual, any help/idea/comments or suggestion are of great help...

Nacho

At the beginning of your macro add the line

Please Login or Register  to view this content.

At the end, add

Please Login or Register  to view this content.

Glad I could assist. Just so you know, if you don't protect your VBA Project, the casual user could open the VBA code window and view your password since it's in plain text. To prevent this, open the VBA window, select your workbook in the left-hand pane, then click Tools -> VBA Project Properties. Click the Protection tab, then check the box for 'Lock project for viewing', and set a password in the two boxes below. Once you save and close your sheet the protection will be in effect. (Just don't forget the password!)