Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default CHANGE PROTECTED CELL VIA MACRO

Hi

Is it possible to change cell A1 from a macro if sheet and cell are
protected?

Response will be much appreciated.
Thanks


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default CHANGE PROTECTED CELL VIA MACRO


SUNIL wrote:
*Hi

Is it possible to change cell A1 from a macro if sheet and cell are
protected?

Response will be much appreciated.
Thanks *


Possible if you know the password.
You can unprotect worksheet and cell via macro.

Why don't you use "UserInterfaceOnly" when you protect the worksheet?
;)


---
~~ Message posted from http://www.ExcelForum.com/

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
Change cell color in protected sheet ansa Excel Worksheet Functions 2 May 2nd 13 12:34 PM
How to change font colour in unlocked cell of protected sheet Michelle Excel Discussion (Misc queries) 2 September 16th 08 05:58 PM
macro that will change the font of a cell if i change a value jk Excel Discussion (Misc queries) 2 July 29th 08 04:39 PM
How to apply a macro to a protected cell greensl Excel Discussion (Misc queries) 1 August 3rd 05 04:51 PM
Macro entering data into a protected Cell?? [email protected] Excel Discussion (Misc queries) 1 July 13th 05 10:30 AM


All times are GMT +1. The time now is 01:02 AM.

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

About Us

"It's about Microsoft Excel"