Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Abdulgani Shaikh
Sent: Apr/Mon/2012 09:29
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fwd: If data in One then another cell to be
unlock
Yes my file is protected a
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Abdulgani Shaikh
> *Sent:* Apr/Sun/2012 03:14
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Fwd: If data
UN protect your worksheet manually or by code. TESTED fine on file presented.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Abdulgani Shaikh
Sent: Sunday, April 15, 2012 4:43 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fwd: If data in One
Is your worksheet protected?
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Abdulgani Shaikh
Sent: Apr/Sun/2012 03:14
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fwd: If data in One then another cell to be
unlock
My
My sheet contains some tax formula and I want to keep these formula
protected, if inadvertently they deleted or corrected, it will not give
correct answer.
If I am protecting the worksheet, it gives error at
Range("A1:J58").SpecialCells(xlCellTypeConstants, 1).ClearContents
Please guide
Thanks a
Mr. Don Congrats,
Well done! Keep it up
Regards,
Muneer,
CC...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice wil
On your protection, why not just leave unprotected...
On your macros, see attached (Sent direct to OP)
‘---
Option Explicit
Sub AddSheetSAS()
ActiveWorkbook.Save
Dim i As Long
Dim s, k As String
s = InputBox("Please Enter INITIALs of Employee as Sheet Name to be added")
For i = 1 To Workshe
