Thread: [Solved] Protecting one sheet is driving me mad.
View Single Post
 
Old 11-02-2025, 12:49 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,527
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
That's not how you apply worksheet protection:
1. Select the whole sheet and choose Format>Format Cells>Locked
2. Select the editable cells and choose Format>Format Cells>Unlocked
3. Choose Format>Protect sheet and apply your preferred options

Getting rid of the read-only prompt is as simple as choosing 'No' at the opening prompt, then using Save As, then Tools>General Options and uncheck the 'Read-only recommended' option.

See attached.
Attached Files
File Type: xlsx Electric-2025.xlsx (55.2 KB, 0 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote