Skip to main content

Excel Tips: Developer > Macro or VBA

Review & Security

Review & Security > Comments

How to add comment to chart in Excel?

How to auto add date and time to comment in Excel?

How to auto-size comment box to fit its content in Excel?

How to change all comment formats in cells in Excel?

How to change all comments’ author name in Excel?

How to change comment indicator color in Excel?

How to convert cell contents to comments in Excel?

How to convert comments to cell contents in Excel?

How to delete all comments in a worksheet/workbook?

How to find and replace text within comments in Excel?

How to insert comments in protected worksheet?

How to insert formula result in Excel comment?

How to list all comments to a new worksheet or workbook in Excel?

How to only copy comments from cells to another in Excel?

How to quickly insert a comment to multiple cells in Excel?

How to reset all comment positions in Excel?

How to show comments when cell is selected in Excel?

Review & Security > Protect cells

How to encrypt/decrypt selected cells in Excel?

How to lock and preotect nonempty cells in Excel?

How to lock and unlock specified cells with a checkbox in Excel?

How to lock or protect cells after data entry or input in Excel?

How to lock or unlock cells based on values in another cell in Excel?

How to lock specified cells without protecting the whole worksheet in Excel?

How to make cell as read only in Excel?

How to prevent specific cell contents from being deleted in Excel?

How to protect cells based on date in Excel?

How to protect or lock cell values based on background color?

Review & Security > Protect Sheets

How to allow edit objects in protected worksheet in Excel?

How to allow external data refresh in protected worksheet in Excel?

How to allow spell check in a protected worksheet in Excel?

How to auto protect a specific worksheet in Excel?

How to automatically protect all worksheets when closing the Excel workbook?

How to check if worksheet or workbook is protected in Excel?

How to lock a sheet position for always visible in Excel Workbook?

How to prevent a certain worksheet from being deleted in Excel?

How to prevent from changing sheet name in Excel?

How to prevent selection of multiple worksheets in Excel?

How to prevent users from printing worksheet?

How to recover lost worksheet protection password in Excel?

How to set password to protect hidden sheet in Excel?

How to toggle (turn on/off) worksheet protection in Excel?

How to unprotect multiple worksheets at once in Excel?

Review & Security > Others

How to apply spell check in textbox?

How to lock or freeze worksheet tab in Excel?

How to prevent or disable edit mode by double clicking cell in Excel?

How to prevent others from inserting worksheet in Excel?

How to protect all workbooks in a folder at once in Excel?

How to protect conditional formatting rules in Excel?

How to protect header and footer in Excel?

How to protect pivot table in Excel?

How to record changing values in a cell in Excel?

How to remember or save previous cell value of a changed cell in Excel?

How to track changes without sharing workbook?