Allowing Macros and VBA to work with Protected Sheets

[SpikeGiles]

I have a workbook with a one sheet front end that has user forms and buttons that launch VBA code, and I want the user to only be able to use these tools, not change anything else in the workbook. However, the macros and VBA do sorting and filtering, change charts etc. When I protect all sheets the macros and VBA don't work. How can I get around this problem?

 

[Jonmo1]

You can add code to unprotect and reprotect the sheet(s)

At key points of your macro

Sheets("SheetName").Unprotect "password goes here"

then let your code do stuff to the sheet
And reprotect it when done

Sheets("SheetName").Protect "password goes here"


Hope that helps.

 

[SpikeGiles]

Thanks jonmo1. So I guess I need to hide and protect my VBA code right? Otherwise the password to protect/unprotect will be easily findable and void much of the value of protecting in the first place.

 

[Jonmo1]

Yes.