Run-time error '1004': Method Range of object_Worksheet Failed (because of wrong code)

Hello to the board!

Anyone can say what in this code is wrong, please?

Please Login or Register  to view this content.

I take this when try to save: Excel Wrong Code - 2018-11-13_11-36-42.png

Thanks in advance!

There's nothing obvious.

Would you upload the workbook so that we can see the problem in context.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

...and after the change of Title, would you upload to this forum rather than a file hosting site please.

Hi,

I don't encounter any problem with the code. I notice that you no longer have the 2nd line beginning ActiveSheet.Protect in your first post

Would you clarify when the problem arises.

Hello,
I actually deleted the second line because it creates another problem: it does not allow me to use a function (a column that works as a hyperlink to open another worksheet in the same workbook). This is the piece of code I'm talking about: Hyperlink Code2.png. And, in general, with the protected worksheet, it blocks me several other functions (maybe the security string should be improved ... I do not know. But with or without this line (the protection line), the problem (Runtime error...) still appears. It appears only when I save the workbook from the Visual Basic Window. I re-send the same file with the protection line I had removed.
Thank you for the help!