this seems to be that it should be easy, but i am having a heck of a time and any help would be greatly appreciated!

what i have is a protected worksheet. but, i want the users to be able to do a mass replace on their formulas if they wish. you can not do that unless you unprotect the worksheet.

first, i thought i would create a command button on my custom toolbar that simply unprotects the worksheet, uses the bulit-in dialog box of xlDialogFormulaReplace, and then protect the worksheet again. well, it works just fine, except if you use it, it disables the normal Edit menu Find/Replace capability. and i don't want to do that. it doesn't give you any errors, just won't work when you select them from the menu. nothing happens at all.

so, i thought i would make the button unlock the worksheet, then use the Execute method of the popup command that is Replace, from the Edit menu. and then lock the worksheet back up.

well, this works great, i prefer the replace dialog you get from the Edit menu anyway. but, it does the Execute, and doesn't stop, it isn't modal. so it just unlocks, shows the dialog box, and locks right back up before you can use the dialog box!!

i thought i could check the zOrder, but found out that none of these things have that property. the worksheet stays active so i can not use the activate event to lock it back up.

surely someone else has done this!! if so PLEASE let me know how you got around it!

thanks much!!!