Share via

Worksheet functions

Anonymous
2023-03-31T14:01:06+00:00

Dear Sir,

I have two buttons on excel sheet as below

Manual buttons put some worksheet in manual and auto put workbook in auto also.

How to do this using worksheet functions like worksheet fucntions.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-31T14:46:25+00:00

    Hi ExcelSuperXW!

    It's not entirely clear what you mean by "put some worksheet in manual and auto". If you're trying to toggle between manual and automatic calculation modes in Excel using worksheet functions, you can use the following formula in a cell:

    =IF(PRODUCT(--(GET. CELL(38,INDIRECT("A1"))=1)), "Manual", "Automatic")

    This formula will return "Manual" if the calculation mode is set to manual, and "Automatic" if it's set to automatic. You can then use an IF statement or a similar formula to perform different calculations depending on the calculation mode.

    Kindly let me know, if you require additional assistance, I will be glad to help further.

    Best Regards, Shakiru

    Was this answer helpful?

    0 comments