Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
modify without unprotecting the sheet, array with wrong format
Hi, Macro1 unprotect sheet1 modifies a lot of the sheet values (A lot of
ranges) and then protect the sheet again, my problem is when the modification action takes place, because takes aprx 1 to 2 seconds, so if the user want to pres cntrl+pause he could do that ( And I dont want the user breaks my program), there is somehow tell VB that although the sheet is protected, VB can write everything he wants with out unprotecting the sheet?????? Also Im using an array and to call it I need to use the following format ar(x,y)(z) I know that the z have something to do with the option base 1 (because when I put option base 1 I need to write my array as ar(x,y)(1) and with option base 0 I need to write ar(x,y)(0)) How I can use my regular format of the arrays??? ( ar(x,y) ) TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
modify without unprotecting the sheet, array with wrong format
Take a look at Application.EnableCancelKey in VBA's help.
Read the warning closely. filo666 wrote: Hi, Macro1 unprotect sheet1 modifies a lot of the sheet values (A lot of ranges) and then protect the sheet again, my problem is when the modification action takes place, because takes aprx 1 to 2 seconds, so if the user want to pres cntrl+pause he could do that ( And I dont want the user breaks my program), there is somehow tell VB that although the sheet is protected, VB can write everything he wants with out unprotecting the sheet?????? Also Im using an array and to call it I need to use the following format ar(x,y)(z) I know that the z have something to do with the option base 1 (because when I put option base 1 I need to write my array as ar(x,y)(1) and with option base 0 I need to write ar(x,y)(0)) How I can use my regular format of the arrays??? ( ar(x,y) ) TIA -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to modify a macro to prevent it from executing if in wrong area of the sheet | Excel Discussion (Misc queries) | |||
Unprotecting a Sheet | Excel Discussion (Misc queries) | |||
How do I modify row column format of Excel sheet? | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Unprotecting a Sheet | Excel Programming |