D
darno
HI!
I am facing a problem with Excel Protection Feature, as i have a macr
in excel sheet that has to do something with range and copy paste fe
columns and format them accordingly, The macro is working fine, but th
problem starts when i protect the sheet for hididng my formulas fro
users. as i execute the macro on a protected sheet, an error popsu
which reads that i can not use range command while the sheet i
protected, But its a must for me to stick to my code, but at the sam
time i need the solution to this problem.
Secondly can any body tell excel to start taking input by enterin
column range via input box.? for example i want a macro which could as
me to enter columns that you want to hide. or could ask me to selec
only the columns tat i wish to print. Can any body help me on these?
Darn
I am facing a problem with Excel Protection Feature, as i have a macr
in excel sheet that has to do something with range and copy paste fe
columns and format them accordingly, The macro is working fine, but th
problem starts when i protect the sheet for hididng my formulas fro
users. as i execute the macro on a protected sheet, an error popsu
which reads that i can not use range command while the sheet i
protected, But its a must for me to stick to my code, but at the sam
time i need the solution to this problem.
Secondly can any body tell excel to start taking input by enterin
column range via input box.? for example i want a macro which could as
me to enter columns that you want to hide. or could ask me to selec
only the columns tat i wish to print. Can any body help me on these?
Darn