Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Sign in
|
Join
|
Help
Home
Blogs
Media
Forums
Groups
All Tags
»
Formatting Cells
»
VBA
(RSS)
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
Formatting
Protection
Show Locked Cells
Here’s a utility to format unlocked cells using conditional formatting so that I can easily see that I’ve set the Locked property appropriately. Private msFormula As String Sub ToggleLockedCellFormat() Dim sh As Worksheet Dim rng As Range ...
Posted to
Daily Dose of Excel
by
Daily Dose of Excel
on Tue, Jun 15 2010
Filed under:
Filed under:
VBA
,
Formatting
,
Formatting Cells
,
Protection
Page 1 of 1 (1 items)
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.