Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection & Macros
How can I protect cells within my worksheets allowing
macros to enter data into them but not users??? Thanks in advance. Catherine. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection & Macros
Hi Catherine!
You need to insert code into your macros: For j = 1 To Worksheets.Count Worksheets(j).UnProtect Password:="not4u2see" Next j <your code that enters data For j = 1 To Worksheets.Count Worksheets(j).Protect Password:="not4u2see" Next j The above allows entry of data into any of the sheets assuming all use the same password. Modify for a single sheet with data entry or where you use different passwords for different sheets. -- Regards Norman Harker MVP (Excel) Sydney, Australia "Catherine" wrote in message ... How can I protect cells within my worksheets allowing macros to enter data into them but not users??? Thanks in advance. Catherine. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection & Macros
Alternatively, set the UserInterFaceOnly argument to true
eg Worksheets("Sheet1").Protect password:="password" UserInterFaceOnly:= True -----Original Message----- Hi Catherine! You need to insert code into your macros: For j = 1 To Worksheets.Count Worksheets(j).UnProtect Password:="not4u2see" Next j <your code that enters data For j = 1 To Worksheets.Count Worksheets(j).Protect Password:="not4u2see" Next j The above allows entry of data into any of the sheets assuming all use the same password. Modify for a single sheet with data entry or where you use different passwords for different sheets. -- Regards Norman Harker MVP (Excel) Sydney, Australia "Catherine" wrote in message ... How can I protect cells within my worksheets allowing macros to enter data into them but not users??? Thanks in advance. Catherine. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection & Macros
Hi,
Usee the ActiveSheet.Unprotect "david"<< your password At the begining of the Macro and when macro is done reset th password. ActiveSheet.Protect Password:="david"<<<< your password. HTH Charle -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection & Macros
Hi Norman,
But can we prevent users not to "see" the password from the macro code? TIA "Norman Harker" wrote in message ... Hi Catherine! You need to insert code into your macros: For j = 1 To Worksheets.Count Worksheets(j).UnProtect Password:="not4u2see" Next j <your code that enters data For j = 1 To Worksheets.Count Worksheets(j).Protect Password:="not4u2see" Next j The above allows entry of data into any of the sheets assuming all use the same password. Modify for a single sheet with data entry or where you use different passwords for different sheets. -- Regards Norman Harker MVP (Excel) Sydney, Australia "Catherine" wrote in message ... How can I protect cells within my worksheets allowing macros to enter data into them but not users??? Thanks in advance. Catherine. --- Outgoing mail is certified Virus Free. (Giden posta virüssüz olarak belgelendi.) Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.703 / Virus Database: 459 - Release Date: 10.06.2004 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection & Macros
I already know that...but thank you anyway.
Best wishes Martyn "Norman Harker" wrote in message ... Hi Martyn! Protect the Macro code. It's under the Tools menu in VBA. -- Regards Norman Harker MVP (Excel) Sydney, Australia --- Outgoing mail is certified Virus Free. (Giden posta virüssüz olarak belgelendi.) Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.703 / Virus Database: 459 - Release Date: 10.06.2004 --- Outgoing mail is certified Virus Free. (Giden posta virüssüz olarak belgelendi.) Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.703 / Virus Database: 459 - Release Date: 10.06.2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel protection & macros | Excel Discussion (Misc queries) | |||
Cell/worksheet protection with macros enabled | Excel Worksheet Functions | |||
Macros/Protection/Pivot Tables...HELP | Excel Discussion (Misc queries) | |||
how to hide a list of macros without password protection | Excel Worksheet Functions | |||
macros and protection | Excel Worksheet Functions |