Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
run macros on protected sheet
Is it possible to protect a sheet (Excel 2003) and still allow macros buttons
to funcion without adding unprotect and protect at the beginning and end (which of course would prompt for the password). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
run macros on protected sheet
You pass the password to unprotect etc.
Activesheet.Unprotect Password:="mypassword" -- --- HTH Bob (change the xxxx to gmail if mailing direct) "widman" wrote in message ... Is it possible to protect a sheet (Excel 2003) and still allow macros buttons to funcion without adding unprotect and protect at the beginning and end (which of course would prompt for the password). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
run macros on protected sheet
I don't want to put the password there. "Bob Phillips" wrote: You pass the password to unprotect etc. Activesheet.Unprotect Password:="mypassword" -- --- HTH Bob (change the xxxx to gmail if mailing direct) "widman" wrote in message ... Is it possible to protect a sheet (Excel 2003) and still allow macros buttons to funcion without adding unprotect and protect at the beginning and end (which of course would prompt for the password). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
run macros on protected sheet
Why not?
You can always protect your VBA Project from prying eyes if that's what concerns you. Select your workbook/project in the VBE and right-clickVBA Project PropertiesProtection. Note: after setting a password to view you must save the workbook. Gord Dibben MS Excel MVP On Sat, 9 Dec 2006 16:31:01 -0800, widman wrote: I don't want to put the password there. "Bob Phillips" wrote: You pass the password to unprotect etc. Activesheet.Unprotect Password:="mypassword" -- --- HTH Bob (change the xxxx to gmail if mailing direct) "widman" wrote in message ... Is it possible to protect a sheet (Excel 2003) and still allow macros buttons to funcion without adding unprotect and protect at the beginning and end (which of course would prompt for the password). |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
run macros on protected sheet
Well you have a choice, you put your password there, you lete the password
prompt pop-up, or you have no password. Your choice. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "widman" wrote in message ... I don't want to put the password there. "Bob Phillips" wrote: You pass the password to unprotect etc. Activesheet.Unprotect Password:="mypassword" -- --- HTH Bob (change the xxxx to gmail if mailing direct) "widman" wrote in message ... Is it possible to protect a sheet (Excel 2003) and still allow macros buttons to funcion without adding unprotect and protect at the beginning and end (which of course would prompt for the password). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Cell References | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
protecting macros for a protected sheet | Excel Discussion (Misc queries) | |||
Mouse pointer becomes hyperlink when sheet protected | Excel Discussion (Misc queries) |