i was wondering if anyone knows how i can have a macro to delete all information in a workbook (only unlocked cells) and have a warning box pop up with a delete confermation before the delete is completed and you can stop the delete if the button was hit by mistake thanks...
Good afternoon Scott McDermott
How about something like this :
HTH
Please Login or Register to view this content.
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Thanks, that nearly works greati have mutipal sheats in the workbook that i need to clear at once, and the macro you tried total clears the cell gits rid of the color format and the boarders.. anything a little less agressive and will hit all the sheets at once? thanks
Hi Scott McDermott
Hey! That's moving the goalpostsThanks, that nearly works great i have mutipal sheats in the workbook that i need to clear at once, and the macro you tried total clears the cell gits rid of the color format and the boarders.. anything a little less agressive and will hit all the sheets at once? thanks
Try this :
HTHPlease Login or Register to view this content.
DominicB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks