I have a fairly large form which I want to have users fill out. While it is possible to have it Read Only so that they always SaveAs I would rather put in a macro to clear the user input fields. I have done this in Excel 2003 and when I try using the same techniques in 2007 I get an Error 400.
I have all the cells (some are merged cells) in a named range and have the following code for clearing them.
I have tried to select the named range manually and right click and choose Clear Contents and it works so I am not sure what I am not doing right.
Help is appreciated.
Bookmarks