protected sheet, allow for macro to work

Easiest is to set the protection via VBA and use the UserInterfaceOnly option.

Example:

Please Login or Register  to view this content.

Set up that way, macros can run unencumbered, but users are confronted with protection restrictions.

Does that help?

Hello

so how would the macro look? sorry...im a little confused as to where the placement of that might go in the code....can u pls advise..thx u

i have 4 worksheets that use that same code..i.e. in VBA, 4 worksheets contain that macro