Have you moved this from the workbook to the sheet? It needs to be adjusted to fit the environment you put it in, do you want it to apply to all sheets (except DATA), or just this specific one?
I'd also recommend you remove Modules a and 2 (your Auto_Open macro doesn't achieve anything!)
CC
I had only included the one sheet in the last attachment, and did not think about it confusing/clouding the big picture. I have attached the whole book this time. The auto_open basically just puts everything back at the beginning each time someone opens the file.
The code I had included in the original message was from another book and works fine for that application. I am just trying to convert it to the needs of this book. The revised code would be placed in the, "PRIMARY EQUIPMENT" and "RESERVE EQUIPMENT" sheets as the other sheets have different requirements.
Last edited by teylyn; 01-31-2010 at 07:15 AM. Reason: quote removed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks