Help with unknown error

[wedzmer]

I'm currently experiencing this error everytime I change a value in one cell on my master sheet..

what does this mean?

how do I fix this?


error.png

[gmr4evr1]

Some of us are unable to see images posted here. If you an attach a sample of what is happening, we might be able to help you better.

[wedzmer]

Some of us are unable to see images posted here. If you an attach a sample of what is happening, we might be able to help you better.

I was trying to upload the file here but it says file size exceed 1000mb..

I uploaded it on an external link FILE LOCATED HERE....please have a look...

the worksheet and macros are password protected with "09193483966" so you can also open it.


thank you for your help!

[gmr4evr1]

If the "master" sheet is the Input Data sheet, I am not getting any errors when I make changes.

[wedzmer]

If the "master" sheet is the Input Data sheet, I am not getting any errors when I make changes.

Yes, the master sheet is the Input Data Sheet... The errors would start when you change the Grade Level value from 1 to 2 or higher (one found on the input data sheet that says Grade & Section). After changing the value here and clicking on the subject's link, and clicking the Update Button (run by macro), the error happens. I dunno why it would have such..

[gmr4evr1]

It seems that when it gets to this line of code

.Shapes("Button A").Visible = True

is where the error happens, whether it is set to true or false. It's happening on every sheet. At least the code wont run beyond that line in any sheet, not sure why though.

[wedzmer]

So that's probably the reason for the error?
Is there ang way to fix it? Coz if I don't change the value for the grade level, nothing seems to be problem... It's when I change it that this error occurs..

[gmr4evr1]

I can't say that it is the reason, nor can I say its not the reason. All I can say is that there is a problem with that line of code, and because of that, the code wont run through the rest of the code, so I can't test the rest of the code.

[wedzmer]

I can't say that it is the reason, nor can I say its not the reason. All I can say is that there is a problem with that line of code, and because of that, the code wont run through the rest of the code, so I can't test the rest of the code.

I see.. that's sad to hear... but still, thanks a lot for the thought! God Speed!

[gmr4evr1]

Sorry I couldn't be more help.

[wedzmer]

I actually got it fixed for the current sheet, my new problem comes after when the copysheet is generated. All the functions within the original sheet are working except the hiding function and an error 400 is generated by excel.