Okay, I've googled this, and I haven't found an answer.

Excel has this funny bug where if you disable the formula bar and click a button, the edit functionality disappears until you exit out of the worksheet and go back in. The way I got around this was to enable the formula bar and then disable it again, which causes the cursor to re-appear.

However - I want to use this "disable editing" bug to my advantage. I have a worksheet called "Config" that contains all the various values that I use in other worksheets, and I don't want users to edit this worksheet.

So I created a dummy button, and sure enough, by clicking this dummy button (with formula bar disabled), it does make the cursor disappear and thus prevents editing. The problem is that I don't know how to activate this dummy button whenever the worksheet is activated. I know the various ways to activate the clickbutton event, but activating the event does not trigger the "disable editing" bug.

Any ideas? Thanks!