Hide Formulae w/ VBA & NO Protect Worksheet or Workbook

[STBTC]

I have searched online for VBA for my worksheet labelled "2019" to hide formulae. In it there are numerous formulae that reference other worksheets. I need a VBA that will hide formulae in the formula bar whenever any of the cells in worksheet titled "2019" is selected; only the calculated result will display. I cannot have the worksheet or the workbook password protected. If possible, I can have the VBA password protected, but I would need to be shown how to do that, too. The simpler the better. I could only find the VBA below, but it is for Kutools for ExtendOffice—something I don’t have. I don’t know if it is something remotely close to what I need. IF the below code could work, I don’t know what xDic and Dictionary—I don’t know what anything is, really—and the range would be the whole worksheet. PLEASE HELP ME, Excel gurus!

Please Login or Register  to view this content.

NOTE: This code is something I acquired from the Internet. In no way is it linked to my worksheet. I iterate: My worksheet is labelled "2019", and I need it to apply to the whole worksheet if a formula is posted in any of its cells. A user may add non-formula content in the future, so I don’t want the VBA to restrict it to just formula-based cells.

[mehmetcik]

I think that I can do what you need.

However not until you comply with the Forum Rules.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[STBTC]

Mwhmetcik, I believe I did what you requested.

[mehmetcik]

Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it.

Please Login or Register  to view this content.

[STBTC]

I pasted the code as instructed, and was given the following error message:

Run-time error '1004':
Method 'Range' of object '_Worksheet' failed

[mehmetcik]

Apologies

It worked Yesterday.

Try Pasting this into a normal Macro Module

Please Login or Register  to view this content.

And

Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it.

Please Login or Register  to view this content.

if this works then delete the first Macro leaving just this code in the normal macro modyule.

Please Login or Register  to view this content.

[STBTC]

The error is still there:

Run-time error '1004':
Method 'Range' of object '_Worksheet' failed

[mehmetcik]

I have attached an example that uses this code:

Please Login or Register  to view this content.