TriMacro
11-15-2004, 02:57 PM
:dunno First - I am trying to "idiot" proof my workbook so that it prevents individuals from copying over the existing workbook. (I want them to always have the original available to them). I've semi-accomplished this by adding a "Save As" button but that still doesn't prevent someone from hitting File:Save and overwrting the original document. This workbook is not available on a network and will reside on individual computers (for an association). How can I prevent this from happening?
:mad: Second - Same workbook, I have used drop down-boxes to list certain items but when I protect the sheet, it won't allow me to change the selections in the drop down boxes. I've tried to remove the protection in the formatting of the individual boxes but it doesn't help.
:bink: Third - What can I do to clear all of the cells and reset the drop-down boxes to a value of "1" after saving? (I will give them the option of reseting after utilizing the "Save As" button and creating a separate "Clear' button)
:blush Lastly and most embarrassing - I was toying around in the beginning and added a calendar object that I can't get rid of and whenever the file opens, it opens to that object which is nowhere near the rest of the information. How do I get rid of it (no toolbar for it) and/or how do I utilize it's values if I keep it?
:mad: Second - Same workbook, I have used drop down-boxes to list certain items but when I protect the sheet, it won't allow me to change the selections in the drop down boxes. I've tried to remove the protection in the formatting of the individual boxes but it doesn't help.
:bink: Third - What can I do to clear all of the cells and reset the drop-down boxes to a value of "1" after saving? (I will give them the option of reseting after utilizing the "Save As" button and creating a separate "Clear' button)
:blush Lastly and most embarrassing - I was toying around in the beginning and added a calendar object that I can't get rid of and whenever the file opens, it opens to that object which is nowhere near the rest of the information. How do I get rid of it (no toolbar for it) and/or how do I utilize it's values if I keep it?