User Posts: Mukesh Dipto
0

## How to Repeat Rows in Excel When Scrolling (6 Suitable Ways)

Sometimes while working with a big dataset we need to repeat rows in Excel when scrolling. This feature helps to keep important rows visible during the time of ...

0

## How to Type Minus Sign in Excel Without Formula (6 Simple Methods)

This tutorial will illustrate simple methods of how to type minus sign in Excel without a formula. Suppose we are trying to type a minus sign in a cell. In ...

0

## How to Calculate Standard Error of Regression Slope in Excel

This article will illustrate how to calculate the standard error of regression slope in Excel. The standard error is the standard deviation of an evaluation. ...

0

## How to Import Stock Prices into Excel from Yahoo Finance

This article will illustrate how to import historical stock prices into Excel from Yahoo Finance. Yahoo! Finance was first introduced by Yahoo! Network. It ...

0

## How to Make an Eisenhower Matrix Template in Excel (With Easy Steps)

This tutorial will be a step-by-step guideline to make an Eisenhower Matrix template in Excel. The Eisenhower Matrix is very useful to fix the management ...

0

## How to Set Decimal Places in Excel with Formula (5 Ways)

This tutorial will explain how to set decimal places in Excel with a formula. Sometimes, we may need to get values up to a fixed decimal place. For instance, ...

0

## How to Generate Report in PDF Format Using Excel VBA (3 Quick Tricks)

This tutorial will illustrate how to generate a report in PDF format using Excel VBA. Suppose a user has to create reports every day for his company. He keeps ...

0

## Lock a Cell after Data Entry Using Excel VBA with Message Box Notification Before Locking

This tutorial will demonstrate how to lock a cell after data entry using Excel VBA with a message box notification before locking. So users will not be able to ...

0

## How to Create a Project Timeline in Excel (3 Simple Methods)

This tutorial will demonstrate how to create a project timeline in Excel. Suppose, we are managing a small project. To manage the project we want to create a ...

0

## Excel Macro to Send Email Automatically (3 Suitable Examples)

This tutorial will illustrate how to use Excel macro to send an email automatically. We can configure our mailing feature using VBA macros. So, using the VBA ...

0

## How to Protect Formulas but Allow Copy in Excel (3 Simple Methods)

This tutorial will demonstrate how to protect Excel formulas but will allow you to copy them. Suppose, we will share our Excel file with other users. Our Excel ...

0

## How to Unprotect Excel Sheet If Forgot Password (4 Effective Methods)

This tutorial illustrates how to unprotect an Excel sheet if we forgot the password. To keep our worksheet or workbook confidential, we set a password. The ...

0

## MS Excel Ribbon and Its Function (Tabs & Features)

In Microsoft Excel, we use ribbon to quickly find and apply different commands. This tutorial will give us a complete overview of using the MS Excel ribbon and ...

0

## How to Replace Text with Blank Cell in Excel (5 Simple Methods)

This tutorial will demonstrate 5 simple methods to replace text with a blank cell in Excel. When working with a dataset, we may need to eliminate specific cell ...

1

## Calculate Conditional Weighted Average with Multiple Conditions in Excel

This tutorial will demonstrate the methods to calculate conditional weighted average with multiple conditions in Excel. While calculating the weighted average ...

Browsing All Comments By: Mukesh Dipto
1. Reply Hello Ruby,
Thanks for your query. If you do not want to see the formula for a blink then you have to do it by protecting the worksheet. You can try the following code:
Sub HideFormulasDisplayValues()
With ActiveSheet
.Unprotect
.Cells.Locked = False
.Cells.SpecialCells(xlCellTypeFormulas).Locked = True
.Cells.SpecialCells(xlCellTypeFormulas).FormulaHidden = True
.Protect AllowDeletingRows:=True
End With
End Sub

2. Reply    