Protect on Deactivate

[AllisterB]

Hi

I have code on a sheet that I want to run when I activate any other sheet.

However it doesn't work - there are no errors - it just doesn't protect the sheet on which the code sits.

Can someone tell me what is wrong.

thank You

Allister

Please Login or Register  to view this content.

[MRUTOR]

Hello,

question: Why you unprotect and protect it in same procedure?
I would use the Sheet name instead of ActiveSheet. and the EnableOutlining can be in the same command:

Please Login or Register  to view this content.

[HaHoBe]

Hi Allister,

could you please make clear to me if you are seeking a code for Shjeets (like stated in text) or Worlbooks (like code)?

You could be looking for the command Private Sub Workbook_SheetActivate(ByVal Sh As Object) in ThisWorkbook where you should exclude the sheet the code ahould not run if you are looking for a code to run in one workbook. The procedure you posted would just run once when any other workbook is activeated.

And I have the same question like Tor about the commands in your code.

Ciao,
Holger

[AllisterB]

Hi

Thank You for your reply.

I have about 40 sheets - is there another way or do I need to in the code name each sheet

Thank You

Allister

[HaHoBe]

Hi Allister,

for one workbook you may use a Select Case to exclude sheets (code goes into ThisWokbook):

Please Login or Register  to view this content.

This might give you an idea how to work on the code.

Ciao,
Holger

[AllisterB]

Thank you
I want it to run on the sheet. Each time the user clicks off the sheet to another sheet I want the code on the sheet to run

Thanks again

Allister

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)