Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is this possible, replacing password protected sheet text with mac
I am using Excel 2003 and have a file where there are 175 sheets, each sheet
is used to collect data for different project - but the same format is used in each sheet to collect data, only difference between those sheet is 'Name of Sheet' which is 1, 2, 3, 4 upto 175. All those sheets are password protected using DataToolsprotect sheet option and my pass word is "project" my problem is that by mistake i have written in cell $I$43 "Start Date" - instead of this there should be "Amount" so i have to change this in all 175 sheet. For this i have to unprotect the sheet first and then type the text and protect the sheet again. which is a time consuming process. Can any one help me with a macro which can do this task ( in all 175 sheet in cell $I$43 in place of text "Start Date" replace by "Amount" and keep the sheet password protected) . Thanx in advance Rajat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing a password protected file. | Excel Discussion (Misc queries) | |||
no password for protected sheet | Excel Worksheet Functions | |||
Importing from Password Protected Sheet | Excel Worksheet Functions | |||
password protected Sheet | Excel Discussion (Misc queries) | |||
VBa, Password protected sheet fails to get unprotected with the same password | Excel Programming |