Clicking on a button linked to VBA code fails to execute

Dear,

Please check the file attached, and have a look at the worksheet "GENERAL".

There is a button called "OFFRE" which is linked to :

1) the below subroutine in the worksheet "GENERAL" to define the preconditions of the button's execution

Please Login or Register  to view this content.

2) the below module to show or hide certain tabs depending on the value defined in the above routine.

Please Login or Register  to view this content.

However, when I click on the button, there is a "400" error without any additional message or warning. I can't figure what is the issue.

(If needed, password: 9583)

Can someone help me please? Thanks

The worksheet is protected and your code tries to change a cell value on it without unprotecting it.

Those buttons both populate G1, which is unlocked, not E1 which is locked.

Your code then tries to select A6 on the OFFRE DE PRIX sheet, which is not active, so that will fail. You should activate it first (or use Application.Goto).