Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
if i have VBA code that uprotects a sheet that is password protected, if i change the password will i have to go through everycode and change each password also?
|
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
short answer: YES
for every piece of code that needs to unprotect that Worksheet but you can use find / replace for entire project to make changes ----- choice wrote: ---- if i have VBA code that uprotects a sheet that is password protected, if i change the password will i have to go through everycode and change each password also? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes, but using EditReplace on your module or project will speed it up.
Gord Dibben Excel MVP On Wed, 21 Apr 2004 14:56:08 -0700, choice wrote: if i have VBA code that uprotects a sheet that is password protected, if i change the password will i have to go through everycode and change each password also? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change Excel password | Excel Discussion (Misc queries) | |||
Change password | Excel Discussion (Misc queries) | |||
re Password Change again | Excel Programming | |||
password change again | Excel Programming | |||
change password | Excel Programming |