Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Protected cells in Protected sheet

The Requirement:
I am trying to protect a sheet and some cells that I do not want thee
regular users to write in but need to write to those cells with VBA code.

The Problem:
I can sometimes write to those cells with VBA without having to unprotect
the sheet first but some times (or on other PC's) the code fails to write to
the same cells.

I can adjust the code to always unprotect but wonder why it works sometimes
and not other?

Can someone please provide some insight!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging cells in a Protected Sheet Protect Sheet but be able to merge cells[_2_] Excel Worksheet Functions 3 June 8th 09 04:21 PM
Merge Cells on Protected Sheet denis mat Excel Discussion (Misc queries) 1 October 10th 08 09:38 AM
Edit text format in non-protected cells in protected worksheet Bonnie Excel Discussion (Misc queries) 2 April 19th 08 04:48 PM
Why can't I merge cells in a protected sheet? triaz[_4_] Excel Programming 2 March 16th 06 01:16 PM
How do I unprotect certain cells in a protected sheet? Lee Garrett Excel Worksheet Functions 1 January 26th 06 04:38 AM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"