Macro not working in Office on the Web

Hi,

Wasn't sure where to list this but I figure as I want a macro to work where better to come.
Sample attached, if you double click any numbered group it will background color change to green, again then it will go back to original color.
This uses doubleclick VBA macro to achieve and works exactly as required

The workbook is to be shared within an organisation and will be using Excel in browser on the web, macro's not supported.
Is there a way to achieve the same results without using macro's so it will work on shared file?
I know I could use CF but that would mean user input, trying to achieve the simplest method

TIA
Tez

The only way would be to use conditional formatting, but you wouldn't be able to use a click event or any automated trigger, you would need to create a switch using a data validation list.

Hi

As you said, you can't use macros for an Excel file while using that file in a web browser.
Your file can contain macros, but they are disabled in the web.

So the only way to do as you want is via CF.

In the attached file, I modified your layout a little to allow the User to Enter/Clear an "x" in a block's-header-row.
This creates the same effect as using the double-click macro, using Conditional Formatting.
The slightly tricky part was to modify your macro a little, to allow both methods to be available when using the Excel file on a desktop.

So, on a desktop, you can either double-click as before, or Enter or Clear the x in any of the block's header-rows.
(The "x" is arbitrary, it can be any non-blank-character you want).

zeddy

Thanks to you both for your help.

I figured CF was the only way to go but just wanted to clarify, I was hoping to have no user interaction but I guess minimal is acceptable lol

@ZZZeddy I like your idea with the "x" so will probably base the final file on your sample. Thanks