De Activate Button

[colinh]

Hi All

I have a workbook with lots of sheets how can I code a button on sheet 1 to de activate all sheets and to the same when I save?

Thanks all

CH

 

[nightcrawler23]

What do u mean deactivate? if u r on sheet 1 the others are automatically deactivated.

 

[colinh]

Hi

Sometimes I have to adjust the same thing on all sheets so I select all of them do the ajustments to all sheets then I need to de activte them again

CH

 

[nightcrawler23]

But deactivating is only 1 right click. right?

Anyways have u tried recording such a macro?