Why does this custom function work when in Break mode?

**MagnusNovak** · 10-26-2023, 07:26 PM

Hi all,

I have a very simple function whose purpose is simply to mirror a cell (A) in a different cell (B) using VBA. The whole point of this "bridge" is to force users to activate VBA / macros in order to get the proper value in cell (B), which then drives the excel template. I was thinking: if macros are not activated, custom functions won't run and cell (B) won't show the value of cell (A).

But apparently, even in break mode, the following custom function works:

Please Login or Register  to view this content.

1. Do you know why this piece of code works even when macros are not activated / when in break mode?
2. Is there a way to adjust the code to make it inactive when macros are off / break mode? (using functions preferably as I'm using that bridge for quite a few values throughout the spreadsheet)

Thanks!

**scottiex** · 10-26-2023, 09:07 PM

It doesn't run in break mode for me.

**TMS** · 10-27-2023, 12:18 AM

Break mode isn't the same as macros enabled/disabled.

Quite often, once you have enabled macros in a workbook, it will become trusted. It may no longer ask, but I suspect that macros are enabled.

**MagnusNovak** · 10-27-2023, 01:22 PM

Originally Posted by TMS

Break mode isn't the same as macros enabled/disabled.

Quite often, once you have enabled macros in a workbook, it will become trusted. It may no longer ask, but I suspect that macros are enabled.

Interesting! I think you're right. The file I've been working on has macros activated (when not, the code does't run at all). I didn't know there was a distinction between macros not activated and break mode ON. So is there a way to make that code NOT work when also in break mode? Basically, I want to prevent users from being able to use the spreadsheet (by blocking the mirroring of the value) if break mode is ON. Maybe by adding a few "bridge" lines that definitely require Break Mode to be OFF to be able to run properly?

**MagnusNovak** · 10-27-2023, 01:24 PM

Originally Posted by scottiex

It doesn't run in break mode for me.

It's weird, when I create a brand new excel file and just add this code, the function doesn't work for me either in break mode. But it does work in the main spreadsheet I've been working on until now..

**MagnusNovak** · 11-01-2023, 10:14 AM

Hi everyone,

Just following up to check if anyone has any idea on how to make sure that this "bridge" VBA function won't work when break mode is ON?

**MrShorty** · 11-01-2023, 10:38 AM

I think we need more information about the problem you are experiencing. Can you put the function in a spreadsheet (along with anything else necessary to recreate the problem), then provide instructions for recreating the issue you are seeing? It seems to me that if we are going to help with a solution, we've got to be able to create the problem on our own systems.

Why does this custom function work when in Break mode?

LinkBack

Thread Tools

Rate This Thread

Display

Why does this custom function work when in Break mode?

Re: Why does this custom function work when in Break mode?

Re: Why does this custom function work when in Break mode?

Re: Why does this custom function work when in Break mode?

Re: Why does this custom function work when in Break mode?

Re: Why does this custom function work when in Break mode?

Re: Why does this custom function work when in Break mode?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] INDEX, MODE & MATCH Array Function will not work on Multiple Columns

VBA AutoFilter does not Work in run mode, only in debug mode

[SOLVED] Countif, mode function formulas doesnt work the way I wish it should be

[SOLVED] mode function does not work

Break Mode

Can I use VBA to check if the sheet(xxx) is in Page-Break mode or Normal mode ?

[SOLVED] Help with Break Mode

Bookmarks

Bookmarks

Posting Permissions